Adding duplicate values in a query

[mooseisloose]

I know what i'm trying to do sounds simple but can't seem to figure out a way to really get it done, here is an example:
i have columns (fields) and respective data as following:

JobNumber Price
55555 200
55555 300
44444 400
44444 200

I want to be able to make a new query out of that to show:

JobNumber Price


55555 500
44444 600

where it eliminates the duplicate job numbers and adds their respective price. So all 55555 job numbers price is added together. Please help =)

[pbaldy]

You want what's called a totals query. Create a query that returns those 2 fields. On the ribbon you'll see an icon that looks like a Greek "E" that says totals. Click on that and you'll see a new row in the query design grid. Change the Price field to say Sum instead of Group By and run the query.

[mooseisloose]

thank you so much, worked perfect!!! knew it was easy just couldn't remember lol

[pbaldy]

Happy to help!