Text box for date range

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

I have a report that gives info based on a date range
expression in a query. In other words, when I open this
report it askes me for the beginning and ending dates and
then displays the data based on the input. What I would
like to do is have the date range being used show up in
the report saying something like Dates from 1-2-03 to 3-
10-03 and I don't want to have to have the report ask me
for the date range twice, which is what I now have.
 
-----Original Message-----
I have a report that gives info based on a date range
expression in a query. In other words, when I open this
report it askes me for the beginning and ending dates and
then displays the data based on the input. What I would
like to do is have the date range being used show up in
the report saying something like Dates from 1-2-03 to 3-
10-03 and I don't want to have to have the report ask me
for the date range twice, which is what I now have.
.
I would use a form with date range text blocks on it to
Click to expand...
open the report from. Make the form invisible when you
click the print button and then on the report use the
forms date range values as the control source ( also use
them for the queries date parameters). Close the form in
the reports On Close event.
 
I have a report that gives info based on a date range
expression in a query. In other words, when I open this
report it askes me for the beginning and ending dates and
then displays the data based on the input. What I would
like to do is have the date range being used show up in
the report saying something like Dates from 1-2-03 to 3-
10-03 and I don't want to have to have the report ask me
for the date range twice, which is what I now have.
Click to expand...

Here is what I do in this situation:

1. In the QUERY I have the following Criteria for the Date Field
BETWEEN [Enter Beginning Date] AND [Enter Ending Date]

This results in a POPUP Window with the Title "Enter Beginning
Date" and a POPUP Windows with the Title "Enter Ending Date".

The Entered Beginning and Ending Dates will determine the Selection
of the Records.

2. In the Form Header I have created two UNBOUND TEXT BOXES, with the
following Control Sources:

Beginning Date [Enter Beginning Date]
Ending Date [Enter Ending Date]

(The Bracketed Prompt of the Control Source MUST BE IDENTICAL
to the Prompts in the QUERY CRITERIA.)

Jonathan Smith
Vice President - Technical Services
Spheniscidae
POB 61741
Phoenix, Arizona 85082-1741
(e-mail address removed)
 
Back
Top