Using same date range on report for multiple queries

[guyver32]

Hi all,

Can anyone tell me if it is possible to input just one date range into a report that is accessing data from multiple table and multiple queries. I can create the report which gives me the info needed but I have to put the same date range in 3 or 4 time before the report is generated.

Thanks

 

[Rabbie]

You should be able to add a WHERE [your date] between #firstdate# and #seconddate# to the datsource query for your report.

 

[guyver32]

Can you elaborate

Hi Rabbie,

Can you please elaborate. To clarify, I have a number of tables with queries asking for staff id and date range and to calculate total numbers over that date range for the specific requirement. So in the report I have got it to ask for the staff ID once but it asks my for the date range for every different table that I try to combine.

eg.

Staff ID
Table 1 = Sickness Days
Table 2 = Targets Achieved
Table 3 = Contacts Recieved

So the outcome I want is a report that calculates totals for that person and presents something like:

Staff ID: 001
Sickness Days in Period = 12
Targets Met in Period = 23
Contacts Recieved in Period = 5

How do I go about it

Thanks

 

[Rich]

Use a form to pass the parameters to the queries

 

[guyver32]

Hi Rich,

Sorry for my ignorance, but I am new to this.

Can you explain how!