Address Query Query

[Lucy02]

Hi there,

I have created a table to show client addresses. The table shows client name, address 1, address 2, address 3 and postcode. I need to pull a query to show all clients which don't have ANY of the address fields completed AND another query to show all those that have something completed in at least one of the fields. Is this possible?!!

Thanks

 

[pbaldy]

SELECT...
FROM...
WHERE Address1 Is Null AND Address2 Is Null AND ...

I'm guessing you can figure out the reverse of that.

 

[Lucy02]

Thanks that's great don't know why i didn't think of that in the first place?!!