Search results

  1. O

    Why does my query run so slow?

    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...
  2. O

    Solved select record on a date between dates in another table

    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]...
Top Bottom