Thanks Mike, that worked but having looked at the result in FH I'm not sure now that it is going to help me. I appreciate the help you and Merenwen have given but feel as if I'm no nearer to having a means of producing a spreadsheet which enables me to check my FH data against my Ancestry data without running just one query to start it off and then relying on manual updates and insertions from then on. Question is : Which is the best query to start with? A Kinsfolk and add info for B,M,and D's or a full Record list to ensure everyone in FH is there to start with and then add people as they are discovered and also add all source info ie census and certificates found.
Having looked back at earlier answers from yourself and Merenwen I think it best not to try and run periodic queries as there is going to be so much manually added info I'm bound to get rows out of kilter.
I think I'll start with a Kinsfolk and then add the additional names from an All Records list I'll get the people and the rows will space correctly and then I can add columns for putting a tick in to show which records have any of B,M, or D's
I'm waffling on! I guess it's best to do something and stop talking about it. I'll post a note later to say how I got on.
Thanks for all your help guys Dagwood
"I haven't failed. I've just found ten thousand ways that won't work" Thomas Alvar Edison
I cleared everything on the Rows filters list , added the Id column as suggested,ran the query and...... Bingo! I now have a spreadsheet with all recorded people plus census data and I now feel I'm ready to start adding B,M and D's to it.
A very big Thankyou Mike. I would never have known what to add and delete to those Query filters without your assistance. Dagwood
"I haven't failed. I've just found ten thousand ways that won't work" Thomas Alvar Edison
This web site was made with WebAPP v0.9.9.3.3, a web portal system written in Perl
All trademarks and copyrights on this page are owned by their
respective owners. Comments are owned by the Poster.
Marble theme based on "Crash" theme by my2cents
Author:
Logged
Creating a spreadsheet from a custom query
