By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Displaying an amount based on a Constant Exchange Rate

P: n/a
Hi,
I have a Constants table with two columns. The first entry in it is
"ExchangeRate, 1.618"

I want to display value in a text box in dollars based on an amount in
a Products table multiplied by the exchange rate in the constants
table.

At the moment I have this in the Control Source of the text box.

=[GermanListPrice]*(SELECT Value FROM Constants WHERE ConstantType =
'ExchangeRate';)

The text box generates "#Name?"

Any suggestions?

Thanks in Advance
Dave
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DFS
David,

Try:

=[GermanListPrice] * DLookup("Value","Constants","ConstantType =
'ExchangeRate'")
"David" <d.*******@student.qut.edu.au> wrote in message
news:c2*************************@posting.google.co m...
Hi,
I have a Constants table with two columns. The first entry in it is
"ExchangeRate, 1.618"

I want to display value in a text box in dollars based on an amount in
a Products table multiplied by the exchange rate in the constants
table.

At the moment I have this in the Control Source of the text box.

=[GermanListPrice]*(SELECT Value FROM Constants WHERE ConstantType =
'ExchangeRate';)

The text box generates "#Name?"

Any suggestions?

Thanks in Advance
Dave

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.