Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What is the best way to display from to dates (from a param query)
- Thread starter jeep2001
- Start date
eti3nne
MIS
- Feb 5, 2004
- 102
- 0
- 0
jeeep2001,
If you are generating the report from a query, then just repeat the parameter (exactly) in a text box on the form and set Control Source: =[Repeat your from parameter here exactly including the square brackets]. Like wise for end date. I usually add the from and to as labels on the report in between.
If the date ranges are entered in a form, then set the control sources in each of the report textbox, mentioned above, to : = Forms!frmMyFormName!MyTextboxName etc.
If you are generating the report from a query, then just repeat the parameter (exactly) in a text box on the form and set Control Source: =[Repeat your from parameter here exactly including the square brackets]. Like wise for end date. I usually add the from and to as labels on the report in between.
If the date ranges are entered in a form, then set the control sources in each of the report textbox, mentioned above, to : = Forms!frmMyFormName!MyTextboxName etc.
- Status
Similar threads
- Locked
- Question