Count Query

[Emma Chapman 123]

I need to run a query that counts the number of descriptions if the period
for example = 200709. I have a table set up with various different
descriptions and i want to count them for each period.
Does anyone know how i can do this using SQL?

 

[Tom van Stiphout]

On Fri, 19 Sep 2008 06:20:00 -0700, Emma Chapman 123

Using a Totals Query, or using DCount.
Both are in the help file.

-Tom.
Microsoft Access MVP