Find records with missing data

[edster]

Hi hope you can help me out,

I have a query which combines several linked tables, the query has about 10 columns, I need to show only the records which have one or more empty fields.

Some records may only have one missing field others may have several.

Any ideas?

Many thanks,
Ed

 

[Bhaughbb]

Here's one quick solution, in the sql:
WHERE (COL1 Is Null) or (COL2 Is Null) or (Col3 Is Null) etc...