Hi all,
First post so be gentle
I have put together a database. I have three tables, only one of which will contain a full year's worth of data at any given time (it's date driven). The other two will contain part-year data.
I have a fourth table which I want to hold the full year's worth of data (it's being referenced elsewhere).
How can I put together a query that "knows" which table to use? Is it possible to do it by a count of records? (The full year's worth of data will obviously contain more records).
Thanks in advance.