Report and Subreport Information

[jycc]

I have created a report that pulls information on construction costs pulling from 3 tables: customer, invoices for materials, timecard information for labor. I want to be able to preview the report by entering a customer ID, then enter the beginning and ending dates for invoices and beginning and ending dates for labor. My problem is when I put these in the criteria fields within the query, the report continues to ask for the beginning and ending labor dates. Any suggestions on how I can get the same time information from these two queries?

 

[dhookom]

Avoid queries that prompt for parameters. Users should enter values into text boxes or other controls on forms. Use the values in the controls to filter forms and reports.

Duane
MS Access MVP