Simple MS Access Count Query?

[andmunn]

I have a Query which returns the following properties:

1) Item #
2) Item Type
3) Date Created
4) Division

Basically, i want the query to return the # of items (i.e// Item Widget) and provie a count for that...

I.E.// if i specify "Feb 09" as the date created, I want the display to look like:

Widget -- All Dates in Feb -- 1424
Widget 2 -- All Dates in Feb -- 600
(item type) -- (date) -- (# of items created)

Any advice how to do this? I tried addding group by "count" under Item type, but it keeps freezing.

If i don't specifiy count - the query returns all the results..and doesn't freeze.

Any advice (there are abotu 1000 results).

Cheers,
Andrew.

 

[ajetrumpet]

read through this faq first on using any aggregrate function, and how do it:

http://www.access-programmers.co.uk/forums/showthread.php?t=135763