* Census places and occupations.

[rodit]

I am trying to write a query which will show the places and occupations of people at successive censuses. Although I can get the places, I am not having much success in attaching the correct occupation. I think that I need to use the Occupation/Date attribute but not sure of how. Also how do I exclude people for whom I have no census records (eg those born after 1911)? My attempt so far lists everybody.
Help would be appreciated.
Roger

[Jane]

I am not sure why you should have a problem finding this in the data reference list.

It's in Individual > Attribute > Occupation %INDI.OCCU[1]% and you will just need to substitute in the year=1901 for the 1 in square brackets.

To filter the output just add two filters on the Rows tab to exclude people born after 1911 and people who died before 1841.

If you need examples just download a couple of the Census Queries from the Knowledge base.

[rodit]

Thanks Jane
As a newcomer to query writing I was unsure where the year was inserted in the expression. However, I have found some examples, have found that, and have been able to complete my self-set task.
regards
Roger