Time period for multiple reports

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!
 
K

KARL DEWEY

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

prothery

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!
 
J

John W. Vinson

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top