Displaying many tables one after the other

[FLabrecque]

I have 3 tables containing with relatively the same layout. I wish to extract the ID of each of these tables using 1 query (that I could later use to access all of these IDs). Joining these tables is not an option (it would probably be too easy!).

Any leads on how to proceed? I know how to do it on Oracle 9i... but this is Access!

 

[sfreeman@co.mer]

Assuming that you only want to see unique values, a union query might work.
Something like:

Select ID1 from TableOneID
union
Select ID1 from TableTwoID
union
Select ID1 from TableThreeID

HTH