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
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