Adding Up

[BillyUS]

Hi

How do i make a query add up all the values in a payment
field which has 4 different price ranges and then give me
an answer of how much income i have recieved from them. is
this possible.

thanks

 

[Jeff Boyce]

You have a payment field that hold ranges? How do you know exactly how much
the payment was?

If you have a field that has a fixed numeric value, you can use a Totals
query to sum that field.