Dates in a Report

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I created a report that the user has to enter the dates
the report is for. I used "Between And" in the criteria
of the date field. Now I would like the same date used to
appear in the header of the report. Ex: If the report is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.

How can I make this happen?

Aurora
 
Aurora said:
I am using Access 2000

I created a report that the user has to enter the dates
the report is for. I used "Between And" in the criteria
of the date field. Now I would like the same date used to
appear in the header of the report. Ex: If the report is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.
Click to expand...

Use a text box in the report header with an expression along
these lines:

="For " & [whatsinthequery] & " to " &
[otherthinginthequery]
 
First of all I want to say THANK YOU for trying to help me.

I am not sure I understand what you are telling me.
In my query I have a QDate field in which the criteria is:
Between[Enter Beg Date] and [Enter End Date].

Do I use [Enter Beg Date] for the [Whatsinthequery]
and [Enter End Date] for [otherthinginthequery]???

Aurora




-----Original Message-----
Aurora said:
I am using Access 2000

I created a report that the user has to enter the dates
the report is for. I used "Between And" in the criteria
of the date field. Now I would like the same date used to
appear in the header of the report. Ex: If the report is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.
Click to expand...

Use a text box in the report header with an expression along
these lines:

="For " & [whatsinthequery] & " to " &
[otherthinginthequery]
Click to expand...
 
Marshall:

This is message number 2. I tried what I thought you
meant and it worked. thank you for very very much.

Aurora

-----Original Message-----
Aurora said:
I am using Access 2000

I created a report that the user has to enter the dates
the report is for. I used "Between And" in the criteria
of the date field. Now I would like the same date used to
appear in the header of the report. Ex: If the report is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.
Click to expand...

Use a text box in the report header with an expression along
these lines:

="For " & [whatsinthequery] & " to " &
[otherthinginthequery]
Click to expand...
 
Hi,

I have the same problem, but I do not fully understand
the answer below. I have a repor that already asks me
for the enter begining date and enter ending date in
order to run the report. I would like to display that in
the report header rather than having to enter the same
information in twice. If you could please be more
descriptive about the below statement I would be very
grateful as I've spent so many hours reading the help
section and trying out so many different things.

Thank you,
David
-----Original Message-----
First of all I want to say THANK YOU for trying to help me.

I am not sure I understand what you are telling me.
In my query I have a QDate field in which the criteria is:
Between[Enter Beg Date] and [Enter End Date].

Do I use [Enter Beg Date] for the [Whatsinthequery]
and [Enter End Date] for [otherthinginthequery]???

Aurora




-----Original Message-----
Click to expand...
used
to
Click to expand...
report
is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.
Click to expand...

Use a text box in the report header with an expression along
these lines:

="For " & [whatsinthequery] & " to " &
[otherthinginthequery]
Click to expand...
.
Click to expand...
 
What that was supposed to imply is that you should use
**exactly** the same thing you used in the query. Just as
Aurora surmised.
--
Marsh
MVP [MS Access]



David said:
I have the same problem, but I do not fully understand
the answer below. I have a repor that already asks me
for the enter begining date and enter ending date in
order to run the report. I would like to display that in
the report header rather than having to enter the same
information in twice. If you could please be more
descriptive about the below statement I would be very
grateful as I've spent so many hours reading the help
section and trying out so many different things.
-----Original Message-----
First of all I want to say THANK YOU for trying to help me.

I am not sure I understand what you are telling me.
In my query I have a QDate field in which the criteria is:
Between[Enter Beg Date] and [Enter End Date].

Do I use [Enter Beg Date] for the [Whatsinthequery]
and [Enter End Date] for [otherthinginthequery]???
-----Original Message-----
Aurora wrote:

I am using Access 2000

I created a report that the user has to enter the dates
the report is for. I used "Between And" in the criteria
of the date field. Now I would like the same date
Click to expand...
used
to
appear in the header of the report. Ex: If the
Click to expand...
report
is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.

Use a text box in the report header with an expression along
these lines:

="For " & [whatsinthequery] & " to " &
[otherthinginthequery]
Click to expand...
Click to expand...
Click to expand...
 
Sorry I was so obscure about it, Aurora, but I am glad to
see that you deciphered it in spite of my weak explanation.
--
Marsh
MVP [MS Access]



Marshall:

This is message number 2. I tried what I thought you
meant and it worked. thank you for very very much.

Aurora

-----Original Message-----
Aurora said:
I am using Access 2000

I created a report that the user has to enter the dates
the report is for. I used "Between And" in the criteria
of the date field. Now I would like the same date used to
appear in the header of the report. Ex: If the report is
for 1/1/04 thru 1/31/04 -- I want this same date to
appear in the header. Non-Access users are going to
using this report, so I need this to be automatic.
Click to expand...

Use a text box in the report header with an expression along
these lines:

="For " & [whatsinthequery] & " to " &
[otherthinginthequery]
Click to expand...
Click to expand...
 
Back
Top