Help with returning summary results with count query

[Roy33]

I am trying to design a query to do the following:

I have an access database that track orders. tbl_orders has a list of all the orders. The table has the order ID, date, the day, and the type of order. E.g:

500 12/12/2003 FRI software
501 12/12/2003 FRI hardware
502 12/12/2003 FRI hardware
503 12/13/2003 SAT electronics
504 12/13/2003 SAT hardware
505 12/14/2003 SUM software
I have a query that summaries the number of orders as follows -- call it query_summary


12/12/2003 3
12/13/2003 2
12/13/2003 1

I am trying to have a query that will summarize the total number of orders for a specfici month. E.g

November 15
December 6

Currently I am writing queries that query queries and I'm hoping there is a faster way than this:

1) query1 - returns the above summary data query, summary_query
2) query2 - performs a count of the number of orders column above (e.g. 3+2+1 = 7).

Is there a way to make a crosstab (or other) query to do this:

November 15
December 7

I can do it now but it takes many queries on top of queries.
Any suggestions -- or is there a good guide to crosstab queries?

Thanks in advance!
David W

 

[r937]

[tt]select format(orderdate,'MMMM')
, count(*)
from yourtable
group
by format(orderdate,'MMMM')[/tt]

rudy