Access 2007 mail merge

[cdimock]

I have the dates in my database as mmmm d"," yyyy. When I merge the data
from my database into my word document the date shows in numerical form. How
do I get the date to show in written form?

 

[Ken Sheridan]

Use a query which formats the date as the source for the merge. In query
design view enter something like this in the 'field' row of a blank column:

YourFormattedDateField: Format([YourDateField],"mmmm d, yyyy")

Don't include the quotes as in the format property of the field in table
design view. Then reference the YourFormattedDateField column in the merge
filed.

Date/Time values are actually stored in Access as a 64 bit floating point
number with the integer part representing the day and the fractional part the
time of day. The Format function returns a string expression, however.

Ken Sheridan
Stafford, England