Using multiple queries for reports

[BigMac4]

Ok i am going to sound like the novice i am but i am hoping that someone will take pity on me and help me out.

Here is what i am trying to acheive:

I have a report that i need to run using a start and end date parameter based on many fields in a query (from a database), i can get it to run ok but because i am trying to look up different details from different fields i have to enter the same two dates about 8 times to run each query. Can i have a report run multiple queries by just entering one set of dates?

Hope that makes sense.

Thanks

David

[Deekay]

This usually happens when thye query that the report is based upon can't find the dates anywhere and hence asks for the dates for each individual record.
The way round this is to have a small pop-up form unbound with asks for the dates. (call it say 'askdate' with two controls boxes to enter the dates - say first_date and second_date)
Then in the first criteria of the first date put (without the quotes marks) '=form!askdate.first_date'
and in the second '=Form!askdate.second date'.
This way you will only have to enter the dates once.

Deekay

[BigMac4]

That sounds like just the ticket, can i use the "And" Function? eg =Form!askdate.second date And =Form!askdate.second date. Will this also look up all fields within these two dates or just the ones entered into the fields.

Thanks again

David

[beacon]

If you have start date and end date as your two date fields, then you will have to enter the criteria in each of the fields.

So, under start date, you would enter

=Form!AskDate!StartDate

For the end date, you would enter

=Form!AskDate!EndDate

You would enter this into each start and end date field in every query that you want to be affected by the parameters.

Here's a link to a site that gives you the step by step on how to create a custom parameter dialog form: http://www.fontstuff.com/access/acctut08.htm

[BigMac4]

Right i think i have it, i will try it out and let you know if it has had the desired affect.

Thanks for your help

David