Common Date Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am generating a report from multiple queries (each of which have their own
[enter beginning date] and [enter end date] prompt). Is there a way to have
a date prompt at the open of the report for a specific date range and tie
that back to all of the queries? Right now I am getting a date prompt for
each individual query when I open the report. Is there an easy way to
"consolidate" all the prompts and just have one at the open of hte report?
--
 
OK - help me out - I couldn't find it on Martins page. Could you walk me
through it or direct me to it on Martins page?
Thanks!
--



Duane Hookom said:
Don't use parameter prompts in queries. Use references to controls on forms.
Martin Green has examples at http://www.fontstuff.com/access/index.htm

--
Duane Hookom
MS Access MVP
--

LV said:
I am generating a report from multiple queries (each of which have their
own
[enter beginning date] and [enter end date] prompt). Is there a way to
have
a date prompt at the open of the report for a specific date range and tie
that back to all of the queries? Right now I am getting a date prompt
for
each individual query when I open the report. Is there an easy way to
"consolidate" all the prompts and just have one at the open of hte report?
Click to expand...
Click to expand...
 
Try this one http://www.fontstuff.com/access/acctut08.htm

--
Duane Hookom
MS Access MVP
--

LV said:
OK - help me out - I couldn't find it on Martins page. Could you walk me
through it or direct me to it on Martins page?
Thanks!
--



Duane Hookom said:
Don't use parameter prompts in queries. Use references to controls on
forms.
Martin Green has examples at http://www.fontstuff.com/access/index.htm

--
Duane Hookom
MS Access MVP
--

LV said:
I am generating a report from multiple queries (each of which have their
own
[enter beginning date] and [enter end date] prompt). Is there a way to
have
a date prompt at the open of the report for a specific date range and
tie
that back to all of the queries? Right now I am getting a date prompt
for
each individual query when I open the report. Is there an easy way to
"consolidate" all the prompts and just have one at the open of hte
report?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top