referencing a table record in query expression 2

[ps32208]

Hi,

I have an expression: Actual Annual Renewal Value $: Sum(([Amount Lcl]))*12*1.868

I want to replace 1.868 with a reference to a table record. It will always reference the same field and same table record.

Lets say the table is called ex_rate and it is record 1.

Can anyone help pls?

Thanks.

 

[ps32208]

I missed Field name out, which is called: Exchange Rate

 

[JoeAtWork]

Replace 1.868 with

(DLookup("[Exchange Rate]","ex_rate"))

 

[jsteph]

You may want to change to:
DLookup("[Exchange Rate]","ex_rate","ID=1")
...if there are more than one record in this table ( assuming adjusting for actual fieldnames).
--Jim