* Query to Show Occupations through the Years

[Marilyn]

Hi, please can anyone advise me as I cant get my head round queries (although new years resolution is to try harder!!).

I am trying to do a query to list all occupations off an individual through censuses 1841 to 1911, I have done one for occupations but it only gives one. This is probably quite easy and I am overlooking something simple but cant find it at the moment.

Any help would be appreciated.

Thank you[confused]

ID:4919

[Jane]

There are two ways to do this. If you want the Occupations in Rows, just create a Fact Query and select the Occupation Fact.

If you want the information in Columns you can either simply increment the index eg

INDI.OCCU[1]
INDI.OCCU[2]
etc

or if you want the Census ones in the columns try
INDI.OCCU[year=1841]
INDI.OCCU[year=1851]
etc

[Marilyn]

Thanks Jane, just what I wanted

[smile]