Calculating unbound fields

[wendy]

I have linked several customer service forms to a parameter query. While some of the fiels are linked to tables, many are unbound fields that a rep uses as a worksheet. Part of the form is an Amound Due section where I have several dollar amounts in a column - the reps would love me if I could get this column to calculate tax and total for them. It's probably something simple - but I'm at a loss.

 

[Adam]

Hi Wendy,

In the control source of the unbound field, type something
like this:

=[DollarValueColumn]*[TaxRateInDecimal]

Where the DollarValueColumn is the name of the column, and
the tax rate is expressed as decimal, ie 10% =
(10/100)...0.10

Regards

Adam

-----Original Message-----
I have linked several customer service forms to a

parameter query. While some of the fiels are linked to
tables, many are unbound fields that a rep uses as a
worksheet. Part of the form is an Amound Due section
where I have several dollar amounts in a column - the reps
would love me if I could get this column to calculate tax
and total for them. It's probably something simple - but
I'm at a loss.

 

[wendy]

Exactly what I needed. THANK YOU!