Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Location
    IL, USA
    Posts
    10

    Unanswered: Creating a Query to generate Month and Year

    Hi,

    I'm trying to create a query that would generate a list of months from January 2006 to the present date. Can anyone help me out with this?

    Example:

    January 2006
    February 2006
    ........
    ........
    June 2011

    Thanks a lot,

    Romit.
    Last edited by romit91; 06-13-11 at 14:34. Reason: Adding more Explanation

  2. #2
    Join Date
    May 2010
    Posts
    601
    You should be able to adapt this example to your needs.

    Generte a list of dates in a year.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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