Time period for multiple reports

  • Thread starter Thread starter prothery
  • Start date Start date
P

prothery

I have a number of reports generated for the same time period. i am having to
enter start date and stop date for each report. Is there a way of specifying
the period once so that it applies to each of the reports? It sounds simple
but beats me.
Please bear in mind I am a novice!
 
Use an unbound form with unbound text fields and reference them in the
queries for the reports.
[Forms]![YourFormName]![StartDateTextBox]
[Forms]![YourFormName]![StopDateTextBox]
 
Thanks - the queris work fine but my unbound text boxes just say the dreaded
#NAME? there must be an easy way to fix this but i don't know what it is - so
a little more help please?

KARL DEWEY said:
Use an unbound form with unbound text fields and reference them in the
queries for the reports.
[Forms]![YourFormName]![StartDateTextBox]
[Forms]![YourFormName]![StopDateTextBox]

--
KARL DEWEY
Build a little - Test a little


prothery said:
I have a number of reports generated for the same time period. i am having to
enter start date and stop date for each report. Is there a way of specifying
the period once so that it applies to each of the reports? It sounds simple
but beats me.
Please bear in mind I am a novice!
Click to expand...
Click to expand...
 
Thanks - the queris work fine but my unbound text boxes just say the dreaded
#NAME? there must be an easy way to fix this but i don't know what it is - so
a little more help please?
Click to expand...

Is the textbox really unbound? If so it should't say anything, including
#NAME?. Open the form in design view and verify that the Control Source
property of the textboxes is in fact completely blank and empty.
 
Back
Top