Need help with totals/grouping

[Leon_SF]

Hello -

I'm pretty new to Access and this forum, and really appreciate any help I can get.

I have a database that tracks, among other things, referrals. One table has the date the referral was received, and another table has the referral source. I want a query that returns the total number of referrals by referral source, for a time period specified by the user - something like this:

Referral Source Number of referrals
Phone 10
Mail 4
email 3

I tried a single query, with three columns: Referral date (where I entered the parameter criteria), and two referral source columns, one with "Group By" in the "Total" row, and one with "Count" in the "Total" row. This returns the total number of each referral received for each day within the time period specified - something like this:

Referral date Referral Source Number of Referrals
1/1/12 Phone 2
1/1/12 Mail 1
1/2/12 Phone 2
1/2/12 email 2

It's close, but not quite what I need. How can I get the total amount of each referral source received during the specified time period, not broken down by day?



Thanks for your help!!!

[pbaldy]

In the date column, change Group By to Where.

[Leon_SF]

Thanks so much! I thought I might have to do something a lot more complicated, but this does exactly what I need. Thank you!!!!

[pbaldy]

No problem, and welcome to the site!