Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    8

    Question Unanswered: Help with a Access Report

    Hey everyone,

    I'm not sure how to make a query do what I need to. Basically I have a Sales table with Date, Name, Location and Total Sales. I want to be able to get a grand total for all Sales on a certain date by location. I'm not sure how to make this work the way I want.

    So basically let's say I have:

    09/21/09 | Aaron | A Location | $1
    09/21/09 | Sarah | A Location | $2
    09/21/09 | Bob | B Location | $5

    I want to get the output:

    09/21/09 | A Location | $3
    09/21/09 | B Location | $5

    How would I go about doing that?

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Create a SELECT query and use a GROUP BY clause. Base your report off of that query instead of the table.

    HTH! Cheers!
    Me.Geek = True

Posting Permissions

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