Missing client details report

[crxftw]

Hello. This one seems like a joke but I am trying to find a best way to design a report that shows me if client is missing any of the details (home number, mobile number, work number, e-mail, payment method) on Clients table and then display it somehow on a report. Any ideas how it would look nice instead of having full list of clients.

Thanks.

[NoellaG]

Hi,

a possible method would be to create a worktable with the fields:
clientID
clientName
clientMissingInfo

Before starting the report:
empty the table with a delete query, fill it using append queries: for instance first select all clients where home number is empty and for each result line add a line with the clientID, name and the text "Home number". Do this for each field you have to check.
Then create a report based on the working table.

Using VBA or a macro this could easily be automated.

gr
NG

[crxftw]

Thanks that's a neat idea will keep it in mind when it's more needed. Right now I manage with just opening Clients table in datasheet view and using blank filters to sort all clients who have any of them blank.

Thanks a lot tho!

[rpeare]

When you're building your report base the report on a query, in the criteria of the query put IS NULL in any field you're concerned about and make sure the IS NULL is in a separate line from any other item that you're looking for. So for instance if you are looking for a missing homephone, cell phone and email only you would have IS NULL in each one of these columns in your query but each IS NULL would be on a separate line.

This should return any person who is missing any of these pieces of information.