More on adding date range to report headers

[Guest]

On the following thread, I have the same problem as the last post - the date
range shows up on my report header, but I have to enter the date range twice
- assuming once is for the query, and once is for the expression in the
report. Is there any way to capture the dates from the query so the dates do
not have to be entered twice?

Thanks.

I have been following this string as I have a report as well that is based
off of a query that you are required to put in the begin date and the end
date.

I put a text box in my header of the report and the text as you stated. I
works and displays the date range in the header of my report which is what I
wanted but upon running the report I am asked to put in the date range twice.

I would imagine that this is generated from the query and the text box in my
header. How do I correct this.

Thanks much

=" Between "&[Enter Start Date]&" And "&[Enter End Date]""
Notice the -&- I added between ---Date] " And----
Have a great day.
Fons

-----Original Message-----
Hello Fons et. al.,

That doesn't seem to be working. I entered the text as you offered below,
though I think you are missing two closing parenthesis for which I included
in another run as so:=" Between "&[Enter Start Date]" And "&[Enter End Date]""

Note that the text between bracketes is as they appear in my Query Criteria
for fldDate. Maybe the error is here?

A little more help would be appreciated. Thank you all in advance.

Hi Alcide
I assume you have an underlying query and in criteria
under the datefield you would place:
Between [StrtDt] And [EndDt]
Than in the report (probably the header) you place an
unbound text box, and in that text box enter:
="Between "&[StrtDt]&" And "&[EndDt]
That will show the filter specifications on the report.
Hope this helps.
Fons
-----Original Message-----
Hello all,

I want to put the Date Range that I get from a Query into
the Header of a
Report.

My query has a field Date, where the Parameter is in the
Criteria row as
"Between [] AND []". The values acquired from the user
prompt I want to
"capture" and put in the Header, I assume via a TextBox.

I looked at Expression Builder, but it doesn't seem to
access the two
parameter fields.

How do I "capture" those two dates and display them in
the Report?

I suspect that I may have to change my Query design to
include the Input
function, of which I have never used before.

Thanks in advance for you assistance.
.

.

 

[Duane Hookom]

Don't use parameter/prompt queries. Get your criteria from controls on
forms. This is much more flexible and provides a much better user interface.

--
Duane Hookom
MS Access MVP
--

On the following thread, I have the same problem as the last post - the
date
range shows up on my report header, but I have to enter the date range
twice
- assuming once is for the query, and once is for the expression in the
report. Is there any way to capture the dates from the query so the dates
do
not have to be entered twice?

Thanks.

I have been following this string as I have a report as well that is based
off of a query that you are required to put in the begin date and the end
date.

I put a text box in my header of the report and the text as you stated. I
works and displays the date range in the header of my report which is what
I
wanted but upon running the report I am asked to put in the date range
twice.

I would imagine that this is generated from the query and the text box in
my
header. How do I correct this.

Thanks much

=" Between "&[Enter Start Date]&" And "&[Enter End Date]""
Notice the -&- I added between ---Date] " And----
Have a great day.
Fons

-----Original Message-----
Hello Fons et. al.,

That doesn't seem to be working. I entered the text as you offered below,
though I think you are missing two closing parenthesis for which I included
in another run as so:=" Between "&[Enter Start Date]" And "&[Enter End Date]""

Note that the text between bracketes is as they appear in my Query Criteria
for fldDate. Maybe the error is here?

A little more help would be appreciated. Thank you all in advance.

:

Hi Alcide
I assume you have an underlying query and in criteria
under the datefield you would place:
Between [StrtDt] And [EndDt]
Than in the report (probably the header) you place an
unbound text box, and in that text box enter:
="Between "&[StrtDt]&" And "&[EndDt]
That will show the filter specifications on the report.
Hope this helps.
Fons
-----Original Message-----
Hello all,

I want to put the Date Range that I get from a Query into
the Header of a
Report.

My query has a field Date, where the Parameter is in the
Criteria row as
"Between [] AND []". The values acquired from the user
prompt I want to
"capture" and put in the Header, I assume via a TextBox.

I looked at Expression Builder, but it doesn't seem to
access the two
parameter fields.

How do I "capture" those two dates and display them in
the Report?

I suspect that I may have to change my Query design to
include the Input
function, of which I have never used before.

Thanks in advance for you assistance.
.


.