Beginner Needs Help

[48Tad]

I am a member of a small rural Fire Department, and I have been trying to create a database that will track our calls. I started with a table I called “CallLog” and added fields for Case Number (Primary Key), date, time of call, on scene time, etc., etc.. For the types of calls I created three lookup fields in this CallLog table …. “Fire” which looks up values from a separate “Fire” table which has values like “Structure Fire, Grass Fire, Vehicle Fire, etc” ….. “Medical Aid” which looks up values from a separate Medical Aid table with values like “Heart Attack, Stroke, Difficulty Breathing, etc.” ….. and “Vehicle Accident” … which is either “WithInjury or WithoutInjury”.
My ultimate goal is to have a report that I could specify a date range and the report would generate the total number of calls … and then give the breakdown as to the number of grass fires, heart attacks, and non injury auto accidents in that period.
My skill level is low (I am taking an online 1a class) and after 2 queries per type of fire can come up with a count … but can’t get it into a report. I’m sure the way I’m trying to do it is way too complicated an my hope is that some kind soul could give me some sort of outline or overview as to how to accomplish my goal.

 

[WayneRyan]

48,

It sounds like you're heading in the right direction
with your table design, etc.

It also sounds like you have one or more queries that
produce your desired information. I trust that you
have discovered the grouping, summation and count
functions available to queries.

As for the date range, on any form, or a new popup
form you can have two date fields and a command
button. The command button will launch your report.
The report's record source is one of your queries.
In the queries date field, make its criteria
something like:

Between Forms![YourForm]![Date1] and Forms![YourForm]![Date2]

The only thing is that when your report runs the query
the form containing the dates must be open.

hth,
Wayne

 

[48Tad]

Thanks Wayne .... I guess I'll have to just chew on it for a while.

Thanks