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?