Hello,

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.

Code:
SELECT [Trustee_Fee]+[Litigation_Guarantee]+[Statutory_Mailings]+[Publication]+[Service
]+[Posting]+[NOS_Recording]+[Rescission_Recordings]+[Assignment_Recording]+[Postp
onements]+[ExtraTrustee]+[Conduct_Sale]+[Affidavit_Recording]+[Deed_Recording]+[T
ransfer_Tax]-[Subtractions] AS Total2
FROM [HI_Fees_and_Costs_local]
WHERE ((([HI_Fees_and_Costs_local].TS)=[Forms].[HI_FC_Total2].[TS]));

Thank you!

David92595