Convert date for Report

[M Haley]

I have a table of dated transactions. I want to print a report which put transactions in sequence of invoice within day. I want the report to break on transaction month and I want to print the month in the heading as January, 2002 February, 2002 etc. I guess my main problem is how to make Access take the date field (defined as short date) "02/02/02" and print February, 2002 in the heading.

 

[RichMorrison]

See Access help for "DatePart". You can select the Month and the Year from a date field and format as full month name, full year, etc.

RichM

 

[antomack]

Try

format([YourDateField],"mmmm yyyy")