Hi There Experts.
Please can you help, I cant get this to work correctly.
I have a table Invoice with a field invoice date. I have created a table to hold euro exchange rates.
I want to use the exchange rate that is valid when the invoice was created to do calculations, so I thought best way was to create an SQL expression field, which I did as follows:
FROM EuroRates, Invoice
WHERE EuroRates."ValidDate" =
FROM EuroRates, Invoice))
I know I need to join the tables EuroRates and Invoice somehow but I can't seem to get it right!
Thanks in advance