mike60smart
Registered User.
- Local time
- Today, 00:37
- Joined
- Aug 6, 2017
- Messages
- 1,913
Hi Everyone
I have the following data in a Table named "tblCurrencyCalculations"
On My Form I have a Control named "Currency"
In another Unbound Control I need to lookup a value from the tblCurrencyCalculations.
So, If ([Currency]="USD",Dlookup to retrieve the value in Row 1 Column GBP (1.362368)
I just can't get the syntax to work for me.
I have tried :- =IIf([Currency]="USD",DLookUp("USD","tblCurrencyCalculations","Currency = '" & [Currency] & "'"))
This returns a figure 1
Any help appreciated
I have the following data in a Table named "tblCurrencyCalculations"
CurrencyID | Currency | USD | EURO | AUD | GBP | CAD | INR | MXN | JPY |
---|---|---|---|---|---|---|---|---|---|
1 | USD | 1 | 1.156454 | 0.730939 | 1.362368 | 0.796875 | 0.013366 | 0.048532 | 0.008972 |
2 | EURO | 0.864712 | 1 | 0.632041 | 1.178037 | 0.689056 | 0.011557 | 0.041965 | 0.007758 |
3 | AUD | 1.368431 | 1.582528 | 1 | 1.86386 | 1.090207 | 0.01829 | 0.066397 | 0.012275 |
4 | GBP | 0.734036 | 0.848879 | 0.536521 | 1 | 0.584919 | 0.009811 | 0.035623 | 0.006586 |
5 | CAD | 1.255114 | 1.451482 | 0.917257 | 1.709638 | 1 | 0.016775 | 0.060903 | 0.011259 |
On My Form I have a Control named "Currency"
In another Unbound Control I need to lookup a value from the tblCurrencyCalculations.
So, If ([Currency]="USD",Dlookup to retrieve the value in Row 1 Column GBP (1.362368)
I just can't get the syntax to work for me.
I have tried :- =IIf([Currency]="USD",DLookUp("USD","tblCurrencyCalculations","Currency = '" & [Currency] & "'"))
This returns a figure 1
Any help appreciated