Using date/time as a control for a text/memo

[Lost in Access]

In Access 2003, I'm trying to use a date field as a control to a memo field.
To be clearer... I have six dates 10/2/2007...thru 12/27/2007 two dates per
month. I have the report grouped by month. I have a header for each group
with the title "This is for the month of" and I want the control box to show
the name of the month in question, ie. October, November,December.
Please post suggestions or questions if my babble isn't understandable.

 

[Tom Wickerath]

If I understand you correctly (??), you want a text box on your report with a
control source similar to this:

="This is for the month of " & MonthName(Month([DateFieldName]))

where DateFieldName is the name of the field with your date values. Make
sure that the name of this text box control is *not* the same as the field
name included in the expression.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________