Search results

  1. L

    Looking up currency conversion according to date

    Hi, This query is driving me insane and I'd love some advice. So. I have a column giving a bunch of revenue values in different currencies, and I want to convert them all into GBP. These transactions are also over a period of time, so I need to convert them using the time-appropriate exchange...
  2. L

    Lookup data across tables using next-highest value

    Hi, I hope you guys can help me with this. (I also hope I can explain it clearly!) So. I have a master database (TABLE 1), and a database that I need to check for accuracy (TABLE 2). One of the things I need to check is price, but Table 2 uses price tiers, whereby the prices from Table 1 are...
Back
Top Bottom