You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Individuals by Home City, State and Postal Code Query
Individuals by Home City, State and Postal Code Query
This query returns a list of individuals by home address.
Query Parameters
Parameter | Description |
---|---|
City Contains |
Enter a city for the query. |
State/Territory Contains |
Enter a state/territory for the query. |
Postal Code Contains | Enter a postal code for the query. |
Query (Default) Fields
Field | Description |
---|---|
Query Header | Displays the query name, number of records returned, and the total number of pages for the query. |
First Name | Lists the individual first name. |
Last Name | Lists the individual last name. |
Title | Lists the individual title. |
Individual Type |
Lists the individual type. |
Individual Member Flag | Indicates whether or not the individual is a member (1) or non-member (0). |
Individual Do Not Publish Info Online | Indicates whether or not to publish the individuals information online. |
PriPhone Phone Number |
Lists the individual primary phone number. |
PriFax Fax Number |
Lists the individual primary fax number. |
PriEMail E-Mail Address | Lists the individual primary email address. |
HomeAddr Primary? | Indicates whether or not the individual home address is the primary address. |
HomeAddr Address Line 1, 2, City, State/Territory, Postal Code, Country |
Lists the individual home address. |