Aristotle Support

Records with Last Year's code

Article ID: 745
Last updated: 07 Mar, 2010

Records with Last Year’s Code but not This Year’s Code

This query can be used to see who had a code from last year but doesn’t yet have this year’s code. If we want to find out who had a yard sign last election but has not got one for this election, we would run this query. This can be used for codes like 2000 Yard Sign, 2000 Supporter, or 2000 Volunteer. For this query, we will be using the Yard Sign code.

 

If you are looking for households instead of individuals, skip down to the Alternate Household Query to begin.

 

Part 1: We want to pull all the records with the 2000 code.

 

 

Join

And

Table

Codes

Field

Code

Relationship

Exactly matches

Value

Yard Sign 2000

 

Click Add to Query

 

Part 2: We want to exclude anyone that has been coded with this year’s code.

 

 

Join

And NOT

Table

Codes

Field

Code

Relationship

Exactly matches

Value

Yard Sign 2004

 

Click Add to Query

 

 

Alternate Household Query - You may want to work with households and not individual records. In that case, you will need to code the entire household before running your query.

 

To code the entire household for Yard Sign 2000:

 

 

Join

And

Table

Codes

Field

Code

Relationship

Exactly matches

Value

Yard Sign 2000

 

Click Add to Query

 

Under Query Options, click Include Entire Household.

 

 

Under Export Options, click Type: Data Updates and Format: Add/Remove Code.

 

 

Click Submit Query.

 

On the next screen, select the code 2000 Yard Sign as the code you wish to set. Click Set Code.

 

To code the entire household for Yard Sign 2004:

 

 

Join

And NOT

Table

Codes

Field

Code

Relationship

Exactly matches

Value

Yard Sign 2004

 

Click Add to Query

 

Under Query Options, click Include Entire Household.

 

 

Under Export Options, click Type: Data Updates and Format: Add/Remove Code.

 

 

Click Submit Query.

 

On the next screen, select the code 2004 Yard Sign as the code you wish to set. Click Set Code.

 

Now, run the query as above and your results will include only households who had a yard sign last election but has not got one for this election

This article was:   Helpful | Not helpful Report an issue


Article ID: 745
Last updated: 07 Mar, 2010
Revision: 1
Views: 425
Prev     Next
Records by Zip Code       Converting Crystal Reports to PDF Format