Month in report header based on dates in data table

T

TomD

I am creating a report based on a table containing transactions for various
days of a month. I would like to have the appropriate month print on the
report. For example, my data may have transactions for May 2, 6, 27, and 30
and I'd like the report to print "May 2007". Can anyone tell me how to do
this?

Many thanks in advance,

TomD
 
F

fredg

I am creating a report based on a table containing transactions for various
days of a month. I would like to have the appropriate month print on the
report. For example, my data may have transactions for May 2, 6, 27, and 30
and I'd like the report to print "May 2007". Can anyone tell me how to do
this?

Many thanks in advance,

TomD
Click to expand...

If you add an Unbound text control to the Report Header and set it's
control source to:
=Format([DateField],"mmmm yyyy")
it will display the month and year of the FIRST [DateField] in the
detail section.
As long as your report is based upon the data for one month, that
should be all you need.
 
J

John W. Vinson

I am creating a report based on a table containing transactions for various
days of a month. I would like to have the appropriate month print on the
report. For example, my data may have transactions for May 2, 6, 27, and 30
and I'd like the report to print "May 2007". Can anyone tell me how to do
this?

Many thanks in advance,

TomD
Click to expand...

Simply put a textbox on the Report bound to this date field (in the Report
Header let's say). Set its Format to

"mmmm yyyy"

so that no matter what day it is, it will print the month and year.

John W. Vinson [MVP]
 
Top