How do I put prompted criteria on a report? 1

[MRJS]

I have a querry that retrieves all employees who submitted a timesheet for a given Week-Ending period (who have a record in the Timesheet table with Week_Ending_Date = x and Status = New). The Week_Ending_Date must be entered upon launching the query (criteria for Week_Ending_Date contains [Enter week ending date:])

This query is used in a "Find Unmatched" query against the Employee table (All employees in employee table where Submit_Req-Flag is true) so that I can compare who has submitted to those who are supposed to submit. This table is then used to generate a report to assist in tracking down folks who have not submitted timesheets that were supposed to.

I want to present the Week_Ending_Date entered for the first query on a report based on the second query. Is there any way to do that?

The date field is not in the second query, since these are people who did not submit a timesheet and therefore there is no record with a Week_Ending_Date.

I know I could add the date field but then the user of the report gets prompted twice for the same date, i.e once for the first query and once for the report. That is not very elegant.

If there is nothing already holding the entered date that I can put in the control source, how do I present the date that was entered for the query on the report?

Thanks for your help in advance.
Mike aka MRJS.

 

[demoman]

If I understand you correctly, you want to re-use your date entry twice, first for searching and then simply displayed?

If so, you can Launch your report from a form. create a form and locate a text box for your date field. On your report add a textbox where you want the date to print. Set the textbox's control source as follows:

ControlSource=[Forms]![FormName]![FormTxtBox].[Value]

This works great for me!