* Query to show Source notes

[mlfreyder]

My Sources widow is unchanged from the default, and I used the "Note" field at the bottom to show what page of a microfilm a record is located on. I'm 3900 records into this data, and I would like to run a query to show the people with the source data and include the page of the film I found the record.

So the source is "Archives Départementales du Bas-Rhin", it is broken into cities, then books with records aka microfilm, and each microfilm has pages. Did I mess up by using the note field?

My query has names and birth and death dates, no issues there, and then I exclude all but the village I want the report on. Then I tried adding the notes, but there are so many, which one is the one that shows by default? See pix it is the "pg 7" note I want to see.

Thanks Mike

[tatewise]

Mike, you need to provide a lot more details, so we can identify exactly which Note field and how to reference it.

What type of Query are you using, e.g. Individual or Fact ?
It tells you at the top of the General tab in the Query window.

What is the Source Citation linked to?
We need to see the top of the yellow Sources For pane that you attached.
Is it linked to the <whole record> or one of your facts such as Birth or Death or something else?

What expression are you using to exclude all but the village you want?

[davidf]

Mike,

I think many of us would have put the "pg 8" on the end of the "Where within Source field" - freeing up the note for other things.

If you use this note field only for the page number you can reference it in an expression.

If you use the field for multiple uses but want to be able to pick out the page number you could with some modification - but I quake at the idea of 3900 records - but if necessary a mass search and replace for "pg " on a backup copy may do the trick.

From this forum one of the most useful tricks I have learned is the use of {=GetLabelledText(%FACT.NOTE2%,"Search text")}. In this example %FACT.NOTE2% points towards the Fact Note. So when describing a voyage I may put in the Fact Note:

Ship Name: Titanic

Then the expression {=GetLabelledText(%FACT.NOTE2%,"Ship Name: ")} will extract the word "Titanic" for use in Diagrams, sentences etc.

If your source fields could amend "pg " to read say "Page Number: " you could then use the expression to find a line in your citation note starting with "Page Number: " (note the space after the colon - makes the formatting work better) and return the text that follows "Page Number: ". It might just work with "pg " - but can you be sure that that sequence will never be used in that field in a different context?

For a citation Note, I think the reference is %SOUR.NOTE2%; depending on your context you may need some referencing between the first % and SOUR, but if you use the expression builder and look for the Note on the Source (Not the Note Record - the NOTE2 is important), you should pick the right reference.

Alternatively provide more details of exactly what you are trying to do and someone will be able to give you a more definitive answer.

[tatewise]

David, that may or may not help.
But until we know what Type of Query and where the Citation is attached we cannot guess the Expression.
e.g. Your %FACT...% expressions only work in a Fact Query and not in any other type of Query and only if the Citaion is on a Fact and not say the <whole record>.
Unfortunately, none of your suggested expressions gets anywhere near a Citation Note field.

[LornaCraig]

...until we know what Type of Query and where the Citation is attached we cannot guess the Expression.

The OP says "My query has names and birth and death dates...". This suggests that he is probably using an Individual query. And as the example given is a baptism register it's reasonable to assume the citation is attached to the baptism fact.

So I think he is asking for the Data Reference for the Note field of the Source Citation attached to the baptism Fact in an Individual query.

The reference for this is %INDI.BAPM[1].SOUR[1].NOTE2[1]%
(If this is not what's required, please give the further details requested by Tatewise)

It can be found here:

Data ref.JPG (55.74 KiB) Viewed 4289 times

[mlfreyder]

Thanks all

It is an individual query.

There are sources attached to birth, death, and marriage dates that I would like the query to display. As i enter data from a birth, I record the date, and source that date. putting the page # in the "where within source" would not work for me, I need to be able to see it without scrolling the window, (which was another question i have). enter death dates, source the page in the microfilm etc.

I have a query built that will report all the people tied to a village, by excluding all but in an expression. my total file has 140000 people in it, only 3900 are tied to the Bas-Rhin records known as ADELOCH. search it, you will see one can search a village, from there one opens books from church or civil records. the books cover birth, death, marriage for certain date ranges. My source starts with the ADELOCH web site. "Where within the source" is the book ID. then i put the page # in the note. I type the date, then select add a source., select ADELOCH from a list. copy and paste the book ID which can be 20-40 characters long, and then type the page.

So it returns names and dates, born, married and died. after each i would like to see the source data. I would limit it to the book ID and the page. My end goal is to provide a historian of the village with a spreadsheet that mirrors the original microfilm starting with births and showing all the people on page 1, 2, 3 etc. I went through the books online and entered all the data. it is in latin from 1660s to 1792. French/German villages. Then I would run a query on the marriages and then another on the deaths, mirroring the microfilm books. Exported to excel it would be easy to manipulate.

it would be great to allow someone to search the data sorted on a field they select. they are not genealogist using FH, but spreadsheets. A query can be exported to a excel file.

Sorry to be long winded but i thought an explanation of the process might help. All I really need to know is where to I find the "Note" field in the list. Selecting source data reveals more and more notes. I have selected over a dozen under birth and I get my "where within..." data but not the notes.

Also I have posted my data online with Geneanet and an exported GEDCOM imports to their program and shows the source data fine, with page #.

Mike

[LornaCraig]

In my previous reply I gave an example for baptism . The same technique applies for other events. The field you want is the (Note) field in the same section as the (Where Within Source) field which you say you have managed to locate. Here is an example for birth:

data ref.JPG (57.11 KiB) Viewed 4175 times

Here is a simple query with columns for just the citation note for birth, baptism, marriage, death, burial:

columns.JPG (32.48 KiB) Viewed 4175 times

Here is the results set:

result set.JPG (22.4 KiB) Viewed 4175 times

[mlfreyder]

Thx Lorna that did the trick!!!

[mlfreyder]

sorry if I made it sound more complicated than it needed to be. I tried all the other "note" but missed that one.