Formating a date

J

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
 
R

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
 
Top