Formating a date

[Jerry]

In an Access query, I would like to create a string that concatenates a
string
and a date. Each quarter this would run and create a string such as:

"NCOA - January 2005"

Is there a function similar to DatePart that would accomplish this?

Thanks,

Jerry

 

[Rick B]

I believe it would be something like:

SomeNewField: "NCOA - "& format([SomeDate],"MMMM-YYYY")

You can look at the "format" command for more help.

Rick B

 

[Douglas J. Steele]

"NCOA - " & Format(Date(), "mmmm, yyyy")