Please help create report with contact source breakdown

[putnammj]

Hi all,

I have a table names Customers and in the table one of the columns is names Source. When clicking on this column a drop down box (with values i entered manually in the wizard) appears which gives me the option of selecting how our customer heard about us. for example leaflet, website, referral, business card, yellow pages etc.

I would like to be able to create a report where I can select a start date and end date (i have worked this bit out already) and also (what i cant work out) is how to have the report show how many people found us via leaflets in that time, how many via the website, how many via referral etc etc.

I would like one report with one query to show the above either on its own like this:

leaflet total = 1
Website total = 2
referral = 1

or at the bottom of a report with all the data like below:

Cust_ID Cust_name Transaction_date Source

1 Bob 1/5/15 leaflet
2 Jane 2/5/15 website
3 Steve 4/5/15 website
4 dave 4/5/15 referral


What i need:

leaflet total = 1
Website total = 2
referral total = 1

Any help much appreciated and please keep it as simple/step by step as possible as just getting started with access

Really appreciate your help!

[June7]

Expressions in textbox in report footer can be like:

=Sum(IIf([Source]="leaflet", 1, 0))

Otherwise use a subreport bound to an aggregate query with the same date range criteria.