calculations in currency

V

veryconfused

I have these columns already created in a query as well as my main table.
What i am trying to accomplish is i have three fields that i need to add
together then subtract 350.00 to equal the fourth field. Basically so the
fourth field will auto calculate. Can anyone help?
 
J

JL

Hi,
If what you want to do is to display the fourth field as (field1+field2 +
filed3) - 350, this is the SQL.

select Field1, Field2, Field3, (Field1 + Field2 + Field3) - 350 AS Field4
From TableWhatever;
 
Top