Searching for records - statistics

[ccondran08]

I have a database which has numbers for different statistics and i would like to be able to search, for example, the past 10 weeks and find out how many time a certain number has been recorded. Any suggestions ??

 

[plog]

Pretty simple stuff. It's called an Aggregate Query, here's a good microsoft link:

http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx