Calculate Percent in Form

[Gotoknow]

Hi,
I have 3 fields as show below and I want the Tax field to show the amount of
tax on an item at 5.1%. All Fields are formatted to Currency. How do I get
The tax field to work and then have it added in to sum a total cost field.

Original Cost Tax Total Cost
$10.00 $ .51 $10.51

 

[Golfinray]

As the record source for total cost, try:
=sum([original cost]*.051)

 

[Gotoknow]

It worked!!
--
Thank you,
Gotoknow

As the record source for total cost, try:
=sum([original cost]*.051)

Hi,
I have 3 fields as show below and I want the Tax field to show the amount of
tax on an item at 5.1%. All Fields are formatted to Currency. How do I get
The tax field to work and then have it added in to sum a total cost field.

Original Cost Tax Total Cost
$10.00 $ .51 $10.51