Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query per month (Access 2000)

    Having defined my sales per liter and per package, i have three coloumns for the sold liters, called l1, L2 and L3.I defined the montl sales per month but i want the query to show the name of the month and not the number
    How could i do it
    My query is :
    SELECT Sum(qryLitersperCustomer.L1) AS SumOfL1, Sum(qryLitersperCustomer.L2) AS SumOfL2, Sum(qryLitersperCustomer.L3) AS SumOfL3, Month([invoicedate]) AS Expr1
    FROM qryLitersperCustomer
    WHERE (((qryLitersperCustomer.afid)=1))
    GROUP BY Month([invoicedate]);

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: query per month (Access 2000)

    Instead of Month([invoicedate]), use [InvoiceDate]-Day([InvoiceDate])+1 and format this column as mmm (for the abbreviation of the month name) or as mmmm (for the full name).

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query per month (Access 2000)

    Thank you for the advice! works great!

Posting Permissions

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