Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    date functions (2000/2002)

    I have a field to store the date in the following format mm/dd/yyyy .

    How can I create a query to give me totals of other fields based on the month in the date field. I want totals by month (i.e: Jan, Feb, Mar etc.)

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: date functions (2000/2002)

    Hi,
    You can use an expression like:
    GroupMonth: month([datefieldname])
    in your query and group on that.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: date functions (2000/2002)

    Create query with two columns :
    Field :Format([YourDateField],"mm")
    Field: YourAmountField
    Select then menu View | Totals
    In the line Total for the first field enter Group By and for the second field enter Sum
    Francois

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: date functions (2000/2002)

    Thanks. That did it! have a good day!

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: date functions (2000/2002)

    If you will ever have data for more than one year in the table, that is going to put all of the data for each month for all of the years together. Is that what you want?
    Legare Coleman

Posting Permissions

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