Querying Data from Different Tables

N

Novice05

I have created 10 tables with the same fields in each table, but different
data in each table. How do I create a form that will look in all the tables
and display the data I queried? I have trouble creating a single query to
search all tables for the specific criteria that I would enter.

Thanks,
Novice05
 
M

M Skabialka

Sounds like what you really need is one table with an extra field
differentiating these different types of data.

Creating a query from one table would be a cinch by comparison.

Mich
 
B

Brendan Reynolds

For the foreseeable future, Joe, the only way to unite Ireland is to
slaughter a million Unionists. Personally, I think that's too high a price
to pay. And if you think there is justice here in the Republic, you're
dreaming.

You post knowledgeable, helpful answers, Joe, and I admire and respect your
willingness to help others with their technical problems. But your shallow,
simplistic, out-dated sloganeering pisses me off, and I'm not going to
listen to it any more. With regret, I find myself forced to add you to my
killfile, and not to read any more of your posts.
 
M

M Skabialka

Isn't it sad that "Love thy neighbor as thyself" is a tenat in almost all
religions, but causes so much division in so many countries.
I'm sorry I asked such a contentious question.
Mich
 
B

Brendan Reynolds

About one thing at least Joseph and myself are in complete agreement - it is
not about religion, it is about economics. Now, can we please drop it?
 
Top