Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    name the months in query? (Access 2000)

    Name the months in the query ?
    I have the following function :
    Month: Format([InvoiceDate];"yyyy-mm")
    And i receive the totals for each month.In place of the month'name i have the number of the moth, as 2001-01. However i want instead of 2001-01 to have the word january on my query,
    instead of 2001-02 to have the word february and so on.Is it possible at all?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: name the months in query? (Access 2000)

    Markus: Try this:

    Month: Format([InvoiceDate];"yyyy-mmm")

Posting Permissions

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