Page 1 of 1

Query for Various Occupations

Posted: 21 Jan 2009 19:31
by Marilyn
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

Query for Various Occupations

Posted: 21 Jan 2009 20:35
by Jane
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]

Query for Various Occupations

Posted: 21 Jan 2009 20:51
by Marilyn
Oh thank you so much Jane, you are so helpful

It is very much appreciated

Marilyn