How do I build a query field expression to total fields chosen by.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have 10 columns in my query, listing products. Some of the products in
the columns may have identical names. If so, how do I build an expression to
have one total for all the products with same names. For example, water may
be listed in column 1, column 4, and column 7. How do I tell column 1 to sum
the totals of column 1, 4, and 7 and not be bothered with the remaining
columns of different identity.
 
Wrong group. This one is for Outlook, which doesn't have queries.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a sales quote sheet - sum totals by license type 1
VBAscript for data matching excels 0
Query to display highest totals 1
Excel A CountIF question... I think 2
Two Totals from the same column 2
Cascading combo/query in tables 0
Totals on a Report 2
sumproduct to calculate total based on non-continuous columns? 1

Back
Top