Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Totals Query (2000)

    I have 5 fields that I would like to use in a totals query (if that is possible). Group Number, Group Name, Prod ID, Prod Desc, FAMembers. I want to Group on Group Number and Prod Id and sum FAMembers. How do I include the Group Name and Product Description fields. I tried Expression and First and Last. First and Last work but I am not sure what First and Last mean.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Totals Query (2000)

    Assuming that all theses fields are in the same table, first and last aren't going to work as expected in a totals query. Build your totals query using Group Number Prod ID and the sum of FAMembers. Save that query and create a new query that joins the saved totals query back to the table to pick up Group name and Prod Desc. It isn't clear what the relationship is between group number and Prod ID, so I can't be more specific.

Posting Permissions

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