Summing up duplicate fields into one?

[helpmeee]

Hey all,

I have a query that contains three headings:

Supplier, Number, Dollars

or

John/ 1123/ $123.45
John/ 1123/ $69.05
John/ 1124/ $3249.34

How do I get the duplicate records (John, 1123) to SUM UP the dollar amounts and turn that into one line? So it would just be John/ 1123/ $192.50. I tried Group By: Sum, I tried changing parameters and I tried setting the number to unique. When I ran the query after my attempts nothing showed up so those clearly aren't working..

Any suggestions?

 

[Kryst51]

In the menu bar at the top find the total button which looks like a greek letter, click on it.

This will add a row into the grid at the bottom set all fields to group by except for the one you want to sum, set it to sum, and that should do what you want.

 

[helpmeee]

In the menu bar at the top find the total button which looks like a greek letter, click on it.

This will add a row into the grid at the bottom set all fields to group by except for the one you want to sum, set it to sum, and that should do what you want.

I tried doing this, I left the other two options "Group By" and "Summed" the dollar value.. when I run the query, I get a dollar amount that's like $723095729067 and doesn't make sense with my original numbers?

 

[Kryst51]

I tried doing this, I left the other two options "Group By" and "Summed" the dollar value.. when I run the query, I get a dollar amount that's like $723095729067 and doesn't make sense with my original numbers?

Can you post your db because it should work.....

 

[helpmeee]

Can you post your db because it should work.....

I'm not 100% sure how to post a DB & I'm not sure if I'm working with confidential information.. but I used a calculator on some of the numbers and some work while others are way off. I wonder if it's just bad data?

 

[Kryst51]

make a copy, stip out the confidential info, zip it and on here hit the "Go Advanced" button, you will then have the option to add an attachment, it will be a button in the shape of a paperclip.