calculations in currency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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;
 
Back
Top