If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reference controls on a dialogue form as the parameters
I am trying to create a dialogue form which asks for start date and end date
and includes a button to run a report. My goal is to enter the dates only once to run the report. Currently I have the date parameters set in the two queries and have to enter the date range twice when running the report. I tried following several answers to similar questions but now when opening the form and entering the dates I am prompted to re-enter the dates 3 times! The report I am ultimately trying to run consists of a main report, rptCallVolume, and a subreport, rptContractsAndHours. Each of those reports are based on a parameter query: rptCallVolume Field: CallDate Table: DailyCalls WHERE [CallDate] = Forms!ReportGen!txtStartDate AND [CallDate] DATEADD("d",1,Forms!ReportGen!txtStartDate) rptContractsAndHours Field: DateOfRecord Table: ContractsAndHours WHERE [DateOfRecord] = Forms!ReportGen!txtStartDate AND [DateOfRecord] DATEADD("d",1,Forms!ReportGen!txtStartDate) I can also post the SQL View if that will help. Thanks for any assistance. |
Thread Tools | |
Display Modes | |
|
|