Newbie reports question

[lroy1978]

Hi All,
I have several queries which I use to look for specific data in my database, each query provides a different set of information. When I run each query I ask for two dates, in order to find the relevant data between these two dates.

I want to bring together the results from several of these queries into one report. As each query asks for two dates, would that mean entering these dates for every query that I place with the report or is there a way to enter the two dates only once?

Many thanks,
Lee

 

[Smart]

You could create a form that has a start date end end date then pass these dates to your queries (form must stay open tho)

 

[lroy1978]

Thanks Smart.

Two more questions if I may.

1) How can I pass parameters from a form to a query (ie the start and stop date)

2) Once I have my results from several individual queries, how can I merge all the results into one report?

Many Thanks,
Lee

 

[Smart]

RE:RE:Newbie reports question

1) How can I pass parameters from a form to a query (ie the start and stop date)

In your wuery in the criteria section of your date column type
between forms![yourform]![yourstartdatefield] and forms![yourform]!yourenddatefield]

2) Once I have my results from several individual queries, how can I merge all the results into one report?

If you can link your queries (by a common field usually a foreign key)
Then create a query and add all your other queries to it (don't forget to link them) then base your report on the new query

If you can't link them
Create a report based on each query

Create a new report and each of the above created reports in it (as sub reports)

 

[lroy1978]

Thank you.