I am making a small database program to run our club. The club members pay in one of 4 currencies when they visit our club and use our facilities. Because of the volatility of exchange rates, we set them manually and change them when needed.
I want to apply an exchange rate to a transaction...
Hi everyone, new here. Wondered if you can help please?
I have two tables- [exchangerates] and [custdates]
What I would like to find is the Rate applicable for each custdateid on their startdate. There may be more than one, but should not be more than one of each currency.
in [exchangerates]...