Please Help Me!

[stew561]

Say I have a table with two fields

[date]
[source]


The table is populated with the following information

[date] [source]

8/1/2006 Website
8/1/2006 Newspaper
8/15/2006 Truck
8/17/2006 Website


I want to have a report that will prompt for a date range and count the numbers of Sources

Example:


8/1/2006 - 8/31/2006

Website 2
Newspaper 1
Truck 1


How can I do this?


Thanks for your help,

 

[Banana]

You may need two query to do this:

First query has "Between #MM/DD/YYYY# And #MM/DD/YYYY#" as a criteria in Date column. Include source column as well.

Then make another query to count source from the first query.

HTH.

Edit: Actually, you really don't need a second query. You can just use an unbound textbox with the expression:

=Dcount("sources", "qtrFirstQuery")

 

[stew561]

Thanks for the quick response.. I'll try it!!!!



Thanks so much again