Access 2007
Existing Data Base:
In performing a Query of a data base that has a field that is Date/Time set to Medium Date, this field has dates that cover multiple years and all months of the year. The field needs to be set to Medium Date to comply with other reports that are required to do.
Problem:
In using this field, how do I separate out only the January or June or December month for a report [having multiple years is no a problem]?
In using this field, how do I separate out a month of a specific year {ex: January, 2009 or May, 2008}?
I want to Thank each individual that responds in advance for their help with this problem.
Bookmarks