T
Tony Lewis
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.
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.