Add the dates to the header report

[Guest]

Hi,
I would like to add the dates to the header report.

I have a parameter query and its criteria is Between [Beginning Month] And
[Ending Month].

I put the text box in the report header and set its control source is the
Between [Beginning Month] And [Ending Month]. That is the way I used to do.
However, this time it didn't work.

Again the criteria is Between [Beginning Month] And [Ending Month]
Please help

Thanks
Chi

 

[Duane Hookom]

Is that the control source you actually tried? There is no "=" or quotes....
Try:
="Between " & [Beginning Month] & " And " & [Ending Month]

 

[Guest]

Thank you so much! Excellent!
Chi

Is that the control source you actually tried? There is no "=" or quotes....
Try:
="Between " & [Beginning Month] & " And " & [Ending Month]


--
Duane Hookom
MS Access MVP

Hi,
I would like to add the dates to the header report.

I have a parameter query and its criteria is Between [Beginning Month] And
[Ending Month].

I put the text box in the report header and set its control source is the
Between [Beginning Month] And [Ending Month]. That is the way I used to
do.
However, this time it didn't work.

Again the criteria is Between [Beginning Month] And [Ending Month]
Please help

Thanks
Chi

 

[Guest]

Duane,

I have the same problem, however I want it to only show the month, so for
data pulled between 4/1/06 and 4/31/06 just show "April" is that possible?

Thank you so much! Excellent!
Chi

Is that the control source you actually tried? There is no "=" or quotes....
Try:
="Between " & [Beginning Month] & " And " & [Ending Month]


--
Duane Hookom
MS Access MVP

Hi,
I would like to add the dates to the header report.

I have a parameter query and its criteria is Between [Beginning Month] And
[Ending Month].

I put the text box in the report header and set its control source is the
Between [Beginning Month] And [Ending Month]. That is the way I used to
do.
However, this time it didn't work.

Again the criteria is Between [Beginning Month] And [Ending Month]
Please help

Thanks
Chi

 

[Duane Hookom]

Take a look at the Format() function that can return the month name from a
date value.
--
Duane Hookom
MS Access MVP

Duane,

I have the same problem, however I want it to only show the month, so for
data pulled between 4/1/06 and 4/31/06 just show "April" is that possible?

Thank you so much! Excellent!
Chi

Is that the control source you actually tried? There is no "=" or
quotes....
Try:
="Between " & [Beginning Month] & " And " & [Ending Month]


--
Duane Hookom
MS Access MVP


Hi,
I would like to add the dates to the header report.

I have a parameter query and its criteria is Between [Beginning
Month] And
[Ending Month].

I put the text box in the report header and set its control source is
the
Between [Beginning Month] And [Ending Month]. That is the way I used
to
do.
However, this time it didn't work.

Again the criteria is Between [Beginning Month] And [Ending Month]
Please help

Thanks
Chi