Query for Various Occupations

Marilyn · Post by **Marilyn** » 21 Jan 2009 19:31

I have managed to sort out how to create a new query but cannot create one with all the occupations of an individual, even if they have had various occupations throughout their life it will only show one.

Please can anyone advise me what I am doing wrong, or is there an easy way to do this.

Thanks for any help

Marilyn[confused]

ID:3381

YouTube · Post by **Jane** » 21 Jan 2009 20:35

You can't in V3 query by events, so you have two options either simplify a copy of an individual summary report to show occupations only.

OR

Add the occupation event as multiple columns and increment the index in each eg

INDI.OCCU[1]
INDI.OCCU[2]
INDI.OCCU[3]

Marilyn · Post by **Marilyn** » 21 Jan 2009 20:51

Oh thank you so much Jane, you are so helpful

It is very much appreciated

Marilyn

Family Historian User Group