Display people missing an address type

[Fadius]

I have a query providing me with data of all people in my database and all of there address types.

What I am trying to do is have those that are missing an address type of primary location to be displayed. This is a QA report to verify that all people in the system have a Primary Location address.

 

[Turkbear]

Hi,
If there is a field in the data that determines that,then use a selection formula like:

IsNull({Table.PrimaryLocationAddressField}) or Trim({Table.PrimaryLocationAddressField}) = ""

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Fadius]

I have a field called address_type. So a person in the query can have multiple results.

Example:

Name Address_Type
John Smith Primary Location
John Smith Billing Address
Mary Smith Billing Address
Mary Smith Mailing Address
John Doe Primary Location
John Doe Mailing Address
John Doe Billing Address




In the above data, I would only want Mary Smith to display as she is missing a address type of Primary Location.

 

[lbass]

Insert a group on a person field (ideally a person ID field, e.g., {table.personID}), and then create a formula {@hasprimary}:

if isnull({table.adresstype}) or
trim({table.addresstype}) = "" or
{table.addresstype} <> "Primary Location" then
0 else 1

Then go to report->selection formula->group and enter:

sum({@hasprimary},{table.personID}) = 0

-LB