HELP please!! finding the sum of values in a field using a query

[Guest]

Using a query, I have to find the sum of all the values in a single field
that correspond with a certain value in the field next to it.

example:
Im trying to find the total weight of fed ex air shipments.
shipment type weight
fedex ground 2
fed ex air 3
fed ex air 2
fedex custom 4

I'm not familar w/ SQL so im using the prompt boxes that list the fields and
under the fields spaces for total, sort, show, criteria, or.

If you could help I would really appricate it. Thanks in advance!

 

[Guest]

Assuming that you only have those two fields showing in the QBE grind, go up
to View, Totals on the menu bar.

Make sure that it says Group By under shipment type and "fed ex air" in the
criteria.

Under Weight change Group By to Sum.