Hi all,

I'm back with yet another date query! ;)

How do I extract just the Month and the Year from a date field? Can this be done in the table itself or would I need to create a query?

Help as soon as possible most appreciated!

Ta

-------------------------------------------------------------------------
St:)rlight

Two functions: Month() & Year()

Part2 of your question, do it in a query...

Greets