Displaying Totals in Report

[Damo1412]

I'm pretty new to databases and am trying to make a referral log database for a mental health charity using Access 2003.

In the database the user will enter various data including gender, source of referral ethnic origin etc. The user would like to be able to pull off reports showing how many males and females have been referred over a certain time, what the referral sources are over a certain time and so on.

I have managed to create queries which will allow the user to select the required dates using the "Between" function. The problem comes to the reports. So far I have only managed to allow the user to select one parameter ie "Male" or "Female" and then produce a report listing each person referred during that time and then after each person's details the total number of "Males" is shown using the COUNT(*) function.

What I would like is a report that just shows the total number of "Males" and "Females" during the selected timescale. The user wants to be able to pull off other reports of a similar nature however I think that once one report has been compiled I should be able to duplicate it for the other ones.

I have attached a copy of the database.

Thanks in advance for your assistance.

 

[boblarson]

Check out the report I made (simple with just the Male / Female group) with grouping on that field and with totals.

 

[Damo1412]

Thanks Bob,

That seems to have done the trick. I'll have a play with it over the next day or two and post back if there's anything else I'm stuck on.


Thanks again,

Damo