Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Wednesday, February 22

Logically Concatenate unrelated Tables in MS Access

OK, I am at a bit of a brain freeze, and thought that I would turn to you, my brilliant readers, for a bit of help. I have a series of unrelated tables in MS Access. They all have identical field structures, but there is no relation built into them.

I would like to construct a query that will return a result that concatenates all of these tables. I don't want to just append all of these tables together; I want to keep them separate.

Ideas? Solutions?