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.

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