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

Query to retrieve the exact excange rate

P: 2

Houston, iīve got a problem... ;)

I am trying to make a subform Details which contains the following information (i am only mentioning the relevant ones)

- Country
- Currency
- Date
- Excange Rate

the information is retrived from the following tables:

- tblCountries
1. ID
2. Name
3. Currency (foreign key - Looks up in tblCurrencies)

- tblExcangeRate (here iīve got a multi-field primary key - date&currency)
1. Date
2. Currency (foreign key - LookUp tblCurrencies)
3. Rate

- tblDetails
1. ....
2. Country (foreign key from tblCountries)
3. Date
4. Quantity
5. Price

WHAT I want?
I want the exchange rate to be displayed in the frmDetails only by typing in the cboCountry and the txtDate.

I already managed to display the currency (througt the foreign key-country, but I just canīt succed in displaying the right excange rate every time (itīs like my querries are not dynamic....I mean, the query is not made for each record-based on the values in the form, but i always get the results from the 1st record I tried)

I am also incertain about the proper relations between tblDetails, tblExcangeRate & tblCoutries

Hope Iīve been clear enough....sorry for my english and in case itīs a stupid question sorry about that too.

Thank you in advance.....
Jan 6 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 374
Is it possible to either post the queries that you're using or if you're using VBA, can you post any code segments. I still need more information as to what kind of relationship you established as well as what relationship you've setup between what would be the main table of the form, and what is going to be the children.


Joe P.
Jan 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.