Month Only Field (Access 2002 SP1)

Topic

New Reply

Hello! I would like to have a field that shows the ‘Month’ only. I currently have a field in a form that gives the current date ( Date()). On the report, I would like to have a field based on the current date that only shows the name of the month.

Any suggestions?

Thanks in advance!
KST

Reply | Quote

Replies

Set the format of the field to “mmm” or “mmmm”. This will show either Jan or January.

Reply | Quote

Awesome! I was all over it…. Thanks allot for the help!

Have a great evening!
KST

Reply | Quote

You have a good morning too!

Reply | Quote