Page 1 of 1

3 new queries in the query store

Posted: 30 Jan 2003 20:20
by bcrosbie
I have posted three queries which others may find useful.  Two are relating to Census data:
The first is a potential source document (checklist) to identify potential census data still to be sourced / recorded.
The second reports on the individuals linked to a specific census year and place (the place parameter uses the 'contains' relationship, so you can enter any part of the place data).

The third query reports on the occupations listed for an individual.  I have only inclused the first 7 occupations for any person, but you can modify the columns to suit your own requirements in that respect.

ID:24

3 new queries in the query store

Posted: 31 Jan 2003 16:54
by Jane
Thanks Bob [grin]

3 new queries in the query store

Posted: 14 Feb 2003 11:29
by bcrosbie
3 More Queries
I have placed these queries in the store today.  I find them useful as preparation documents prior to a visit to the Records Office, as they highlight potential events to be researched.  The criteria for record selection is that the date of the event is incomplete (i.e. has a range [before, after, between]or is approximation or estimated).
Would be interested in users comments!