Report selecting data from multiple unlinked forms by data range

[llitvin]

I have a database where data is entered in multiple forms. Each form record has a date and time entered with it. The records do not have any relationships to other records on different forms.



I would like to generate a report that selects data records from different, unassociated tables that are within a specified date range. I would like to be able to enter the start date/time and end date/time and have all the records in that range populate the report.

Any suggestions would be appreciated.

[June7]

Maybe have a subreport for each table. Each subreport would have parameterized query as RecordSource. The query would reference controls on form for the criteria input.

[llitvin]

Thank you for the idea of the subreport. I would like to use up to 10 sub reports on 1 report. It seems that it is asking me for query parameters for each of the subreports, even if the parameters have the same name. Is there any way to input the query parameter value once and have it be read by all the individual queries?

Thank you for your help.

[June7]

Have the criteria input on a form. Have each query refer to the same form controls.

[llitvin]

June7,
I created a form with with the inputs for start and stop dates. They are ShiftReportStartTime and ShiftReportStopTime. I am not sure how to reference them in the criteria parameters of the query. In the criteria of the query I typed:
Between [ShiftReportStartTime] And [ShiftReportStopTime]
I entered values in the table for both fields, but they are not referenced when I run the query. It is asking me to enter the values manually.

Once again, I appreciate the help.

[June7]

Need to include Forms!yourformname as prefix in the reference.

Between Forms!yourformname.ShiftReportStartTime And Forms!yourformname.ShiftReportStopTime

[llitvin]

I figured it out. Thank you for the help.