ACCESS FEED: [MS_AccessPros] Trying to add two calculated fields in a form

Minggu, 28 Agustus 2011

[MS_AccessPros] Trying to add two calculated fields in a form

Great Day, I have a subform that adds auto parts to a particular repair. I placed a text box (txtPartsSubTotal) in the footer of the subform. the record source for txtPartsSubTotal is

=Format(Sum([PartTotal]),"$#,###.00")

PartTotal is a field in the table that permits the user to enter the price of a particular part.

Then I add sales tax with the following line in the record source:

=Format(([txtPartsSubTotal]*0.06),"$#,###.00")

After this I want the form to add the two fields to give the grand total in a field named txtPartsTotalCost, and the Record source is

=Format(([txtPartsSubTotal]+[txtPartsSalesTax]),"$#,###.00")

this code treats txtPartsSubTotal and txtPartsSalesTax like a string and simply connects the two numbers into a string. I have formatted both text boxes to Currency.

thanks in advance