Query on Address

rfj1001 · Post by **rfj1001** » 16 Apr 2005 13:02

I'm developing a query to search residence records for a particular street name.

Using the INDI.RESI[1].ADDR field I can pick up any records where the street name is the first occurence of this field. But the query seems to be missing the street name where it is the second or subsequent residence for that person.

Can SKS help out.

TIA

Robin

ID:889

YouTube · Post by **Jane** » 16 Apr 2005 13:17

can you confirm you are using 'contains' any you are also adding records for

%INDI.RESI[2].ADDR% with the same parameter.

If you upload your query I can have look latter, off to a wedding now.

rfj1001 · Post by **rfj1001** » 16 Apr 2005 14:51

Thanks for the offer at looking at the query. It's working as per your reply - not very elegant though (and info like other addresses is coming through).

Essentially, I've got two families who lived close together in Bodley Street over three census periods. They have the same surname but I haven't yet managed to connect them. So I was trying to extract the info from FH to try to help me.

YouTube · Post by **Jane** » 16 Apr 2005 21:13

This is one occasion when one of the wish list items, namely queries on Events would help. Remember to add a column for the second/third residences.

Family Historian User Group

* Query on Address

Query on Address

Query on Address

Query on Address

Query on Address