Calculating unbound fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
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.
 
Back
Top