Need Help Converting Access Sql To Tsql
I have a calulation I need to make, and I almost have it. But I need a way of making a the TS# (ID#) equal to the current TS# of a front end access form. The access version of the SQL statement is written below. I think the only thing I need to figure out is how to replace the underlined portion of the code.
ransfer_Tax]-[Subtractions] AS Total2