Closed Thread
Results 1 to 3 of 3

Using Date/Time field set to Medium Date to Query for individual months

  1. #1
    Registered User
    Join Date
    10-24-2011
    Location
    Pensacola, Florida
    MS-Off Ver
    Excel 2007
    Posts
    15

    Cool 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.

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Using Date/Time field set to Medium Date to Query for individual months

    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

  3. #3
    Registered User
    Join Date
    10-24-2011
    Location
    Pensacola, Florida
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Using Date/Time field set to Medium Date to Query for individual months

    Moderator


    Please delete this post and close this post

    Many Thanks

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1