Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access Tables
Resolved · Urgent Priority · Version 2003
Reply Mon 24 Aug 2009, 15:14Delegate Vishal said...
Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Advanced course
Access Tables
Hi,
I did not get a response to the questions below, can you please help to respond:
- please explain how to import a table of data from excel into an access table.
- the table in question provides closing USD:EUR forex rates for each day over past year, which I need to use to convert sales numbers in a seperate table. please explain how I can set up query that links the two tables and how to multiply sales number by fx rate. i would like to do this in access rather then excel.
For upcoming training course dates see: Pricing & availability
RE: Access Tables
Hello Vishal
Thank you for your question.
Apologies for the delay - I believe a trainer has responded to your original post now.
Kind regards
Amanda
Reply Wed 26 Aug 2009, 08:35Delegate Vishal said...
RE: Access Tables
H Amanda, I have asked the following follow up question but did not get a reply. Can you please forward to Simon. Thanks.
Thank you for your response. I will try this on wednesday when back in office.
The sales figures are in an existing access table which has numerous other fields detailing various aspects of sale (client, amount, currency, settlement, product etc.).
I do not see how I can link the forex table to the sales table. The only common field is the date, but they do not have same string of values. The dates on the forex table are continuous (ie every day this year) whereas the dates on the sales table are broken (and only occur when transactions are made and there may be multiple on any given day). Do you know how I could link the tables?
|