Calculation Field in form

  • Thread starter Thread starter Keith Ward
  • Start date Start date
K

Keith Ward

Hi,

I want a field displayed that performs a calculation on a field within the
form with a value from another table.

Eg Price * Conversion Factor

Price is in the form, and conversion factor is in another table. I want the
result displayed in the form.

I just have #name? In the field.

What have I done wrong.

Thanks

Keith
 
Since Conversion Factor is in another table you'll need to perform a lookup
of the desired value. This can be done through the DLookup function. The
expression could be something like:

=[Eg Price] * DLookup("[Conversion
Factor]","YourTableNameContainingConversionFactor","Your criteria entered
here to pull the appropriate conversion factor value")
 
Back
Top