Record Aggregation in Access

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

Guest

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,
 
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?
 
Change Group BY to SUM under the dollar amounts.

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