Using Date/Time field set to Medium Date to Query for individual months
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.
This is a duplicate post, please request a moderator delete this post and then continue the thread in your original post.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Moderator
Please delete this post and close this post
Many Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks