Help needed Calculating amounts

[zookeeperbobbie]

Hi- I have a table with three rows of sales- I need to create a new column that will give me the total of all three. I have tried doing formulas and a query but Its just not working--- I;m getting all kinds of errors... Any help would be greatly appreciated.

(eventually i am going to insert either the table or a query into a form to make it a subform)

 

[Joe4]

Create a new query. Add the Vendor Field twice. Then click on the Totals button (looks like a Sigma). In the second Field, change the words "Group By" under Totals to "Count".