grrrrrrrr Riddle me this:

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

Guest

Ok. Here goes: I have a report based off of a table which holds inventory data. It's a small inventory of about 300 pieces. WHat I need on the report is a sum of each type. Like it lists all the Chassis and then I need for it to give me a quantity of them and then list all the meters and then give me a sum of them etc.....help!
 
Tina,

You need a Totals query.

Assuming you have a field in your table which identifies
the type, drag it, the inventory field, and no others to
the query grid in Design View. Change to Totals mode with
View, Totals. Set the Total row to Group By for the Type
field, and Sum for the inventory field.

HTH
Kevin Sprinkel
-----Original Message-----
Ok. Here goes: I have a report based off of a table
Click to expand...
which holds inventory data. It's a small inventory of
about 300 pieces. WHat I need on the report is a sum of
each type. Like it lists all the Chassis and then I need
for it to give me a quantity of them and then list all the
meters and then give me a sum of them etc.....help!
 
Tina said:
Ok. Here goes: I have a report based off of a table which holds inventory data. It's a small inventory of about 300 pieces. WHat I need on the report is a sum of each type. Like it lists all the Chassis and then I need for it to give me a quantity of them and then list all the meters and then give me a sum of them etc.....help!
Click to expand...


Another way is to use Sorting and Grouping (View mwnu). Set
the group to the type field and specify Yes for Header and
Footer (in the lower part of the window). Move the type
text box to the group header. In the group footer section
add a text box with an expression like:
=Count(*)
to see the number of records in the group, or, more likely:
=Sum(quantityfield)
to see the total quantity in the group.
 
I had assumed that each record held a quantity of each
entry, and you were looking to total the qty of each type,
like:

Type: Widgets

Part Description Qty
=================== ====
Blasendorfs 20
WhoDidIts 30

Sum of Widges: 50

Type: Gizmos, etc.

It looks, however, that each record represents one piece
of equipment, and that you want a count of each part
description. Is this correct?

If so, group your report on Part Description, and place a
text box in the group footer with the control source set
to:

=Count([Part Description])

HTH
Kevin Sprinkel
-----Original Message-----
Okay your "type filed" will be the same as my "Part
Click to expand...
description" but I am not following you on teh inventory
Field...I have it set up like this"
 
Back
Top