Show dates on report

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

Hi
I have created reports which are generated by looking up records from a
recordset using a from date and to date. The dates are entered by the
user who is prompted when opening the reports. How can I get the from
and to date to be displayed on the report

Any help is very much appreciated
 
You really should be providing a form with text boxes for entering dates.
You could then use a text box on your report with a control source like:
="Between " & Forms!frmDates!txtStart & " and " & Forms!frmDates!txtEnd

If you want to stay with parameter prompts, you can replace the form control
references above with your actual parameter prompts.
 
Hi Kay - from the Toolbar pick the Text Box, place this where it is you want
in on your report. In the Unbound section put =[date] replacing [date] with
whatever your user enters when choosing the date. Can use 1 or both of the
dates. Hope this was what you were after. Yours Dika
 
Back
Top