Query - How to filter criteria from tables

[anoble1]

See picture.
I have some fields under criteria I would like to show. Example I would like this query to pull all part numbers in these 3 tables on this main query. What am I missing or how can this be done?

How can i make this query show all the records in all those tables? Each table has about 15 records (15 part numbers)

[NeoPa]

Perhaps you could rephrase the question so that it makes clearer sense?

I gave up trying to work out what you should have said after the first couple of tries left me scratching my head.

[Rabbit]

I'm confused as well, the title says you want to filter the tables, but then you say you want to show all the records. You can't do both. If you want to show all the records, then don't filter anything.

[twinnyfo]

anoble1,

I think what you need is a UNION Query, which will list all the Parts from each Table. For example,

SELECT PartNo, PartDesc FROM Table1 
UNION ALL 
SELECT PartNo, PartDesc FROM Table2 
UNION ALL 
SELECT PartNo, PartDesc FROM Table3 
GROUP BY PartNo, PartDesc 
ORDER BY PartNo;

[the GROUP BY clause will consolidate any duplicate parts]

Also, this is just a guess, and we have no idea what your Tables are about (or their relationships).

Don't know if this hepps a who' heap or just confuses matters more.