Month on report based on data records

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

Charles G via AccessMonster.com

I create a lot of month end reports and I need to state the month on my
report. However, I can' t use a default month textbox with, for example,
=Format(Date(),"mmmm"), because a lot of times I run a report for October
data in November.

I need something in my report that recognizes the date data in my query and
assigns a month for my report. ie. (October 2005), (October) (From 10-1-05
through 10-31-05) or something of that nature.

Thanks,

-Charles-
 
Well, How did you specify the date in your query?

If you asked the user to enter it with a prompt, then you can use that same
prompt in the report.

If, under your date in the query, you have something like...

Between [Enter Start Date] and [Enter End Date]

Then in your report you can do ...

="Report data for the month of " & Format([Enter Start Date],"mmmm")
 
Rick:
That's exactly what I needed and I appreciate such a quick reply. Thanks Rick!


-Charles-
 
Back
Top