Sum In a Query

[Berksy]

Hi everyone,

My Access Knoweledge isnt brilliant but I have a query with many columns.

I wish to add together 2 columns so that there is total at the end of each row.

Column 1 contains Net Cost
Column 2 contains VAT

Therefore in the new column I wist to calculate Gross Cost.

Im sure this is simple but after ages searching the Help and internet search, im none the wiser! Any help will be greatly appreciated.

Thanks in advance.

 

[MStef]

Write some records, (from your table),
and write a result you want to get in the query.

 

[cooh23]

Hi everyone,

My Access Knoweledge isnt brilliant but I have a query with many columns.

I wish to add together 2 columns so that there is total at the end of each row.

Column 1 contains Net Cost
Column 2 contains VAT

Therefore in the new column I wist to calculate Gross Cost.

Im sure this is simple but after ages searching the Help and internet search, im none the wiser! Any help will be greatly appreciated.

Thanks in advance.

In query design view, add the 3rd column Gross Cost: ([net cost]+[VAT])

For example, If your data is in table1 and you have 2 columns Net Cost and VAT, then you can use the query below to add Gross Cost.

SELECT Table1.[Net Cost], Table1.VAT, ([Net Cost]+[VAT]) AS Gross
FROM Table1;

 

[Berksy]

Thanks Cooh23, greatly appreciated