Extracting & separating the dates

Y

ysk31

I'm pretty new to Access and I need your help. I need to group the months
together from a column with dates in m/dd/yyyy. How do I just separate the
month from the date and save it in a different column? Do I do this in a
query?
 
E

Eric Blitzer

There is no need to store it in the table. whenever you need to see month
only use

Format([Datefield], "mmmm")
 
Top