Calculation Field in form

[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

 

[Guest]

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")