Trying to total records with common characteristics via query.

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

Guest

I use Access 2003 and I am in the kitchen business. Prior to now, I have
ordered one kitchen at a time using access. The method is: "Client" is one:
flowing to "Project" which can be many (kitchen and bathrooms): to "Order
Details" which is a listing of each cabinet in a project space, identified by
characteristics; i.e. fields for type, height, width, depth, hinging, etc.

I find myself doing large buildings now where there will be several of the
same kitchen ('Project') in the same building ('client').

I would like to be able to extract the orderinformation in a different way,
which would be to find all the identical cabinets for a 'client' and assign a
count to to it, so that instead of sending orders of say 67 kitchens to a
vendor, I would send one order with broken down by quantities of specific
types.

I am on the verge of opening a vein, and my supplier in Italy is not thrilled.

If anyone has any suggestions I would be very appreciative.

Mitch
 
Mitch said:
I use Access 2003 and I am in the kitchen business. Prior to now, I have
ordered one kitchen at a time using access. The method is: "Client" is one:
flowing to "Project" which can be many (kitchen and bathrooms): to "Order
Details" which is a listing of each cabinet in a project space, identified by
characteristics; i.e. fields for type, height, width, depth, hinging, etc.

I find myself doing large buildings now where there will be several of the
same kitchen ('Project') in the same building ('client').

I would like to be able to extract the orderinformation in a different way,
which would be to find all the identical cabinets for a 'client' and assign a
count to to it, so that instead of sending orders of say 67 kitchens to a
vendor, I would send one order with broken down by quantities of specific
types.
Click to expand...


I think you want to use a Totals (Group By) query. In the
query design window, use the View - Totals menu item.

Then, set the Total row for each field to Group By for the
fields that define a units characteristics and Sum for the
quantity field. Make sure you remove fields that are not
needed for the calculation (e.g. order detail primary key,
etc).
 
That did it, thanks I really appreciate it.

Marshall Barton said:
I think you want to use a Totals (Group By) query. In the
query design window, use the View - Totals menu item.

Then, set the Total row for each field to Group By for the
fields that define a units characteristics and Sum for the
quantity field. Make sure you remove fields that are not
needed for the calculation (e.g. order detail primary key,
etc).
Click to expand...
 
Back
Top