Hey All
I'm treading water in Access again :-/
I'm pulling together some data from various locations, one price field in has two different versions, a "now" and a "future" both held in different Tables.
I want to be able to edit my Query so that; "If the price exists in the Future, use the...