Record Aggregation in Access

R

R. Lee White

First off- I am not a programmer and know nothing about writing SQLs. I do
however know enough about access to link tables and run queries. I have a
query that is over half million lines, and would like to consolidate the
records by a common field (catalog number in this case), which would
consoldate the query to 6000 lines. How do I go about it? I read in one of
the forums to use the group-by operator in queries, but I see no such
operator.

Thanks in advance,
 
R

R. Lee White

Once I have the "Group By" up, how do I consolodate all records with the same
catalog number into one row, summing the dollar amounts in quantities of all
like cat. numbers?
 
J

John Spencer

Change Group BY to SUM under the dollar amounts.

You have choices of Sum, Max, Min, Avg, etc.
 
Top