Empty record query problem

[Ali29J]

I have a query which looks up from mulple tables, and it filters using criteria [forms]![RFQTracker]![RFQ], but if any of the other corresponding records which are being filtered are empty then it will not show the reocrds that are populated, how can I get round this??

Anyone have any ideas?

 

[Crowley16]

you're not being 100% clear on what you mean...

but it sounds like what you are doing is:
Joining n tables together on various fields...
Then quering this join...

and your problem is that when some table's records are empty, none records are returned...

if that's the case, then what you need to be doing is using Left Join instead of Inner Join.
If you are using the query builder, then dblClick on the link between your tables, and make sure you select the "select ALL records from tblBlah and only those..." Option...