Month Name function problem in MS Access query - TechRepublic
Question
March 25, 2007 at 05:03 AM
traceyae

Month Name function problem in MS Access query

by traceyae . Updated 19 years, 2 months ago

I have a simple table containing order number, order date, cd number, cd title etc. I have imported 5000 records and need to analyse the data for trends. I need to create a query that will extract and list month names and the number of orders for each month. The closest I have got to this has resulted in a parameter query which I do not want. I want to view all months. Can anyone help?

This discussion is locked

All Comments