Search results

Sorry, when I say 'removed at the outset' re LIS, I mean removed from this family.. she appears in family LD.

Sisters would naturally follow oldest to youngest, and then Brothers. Then you can list the cousins for LIS82 sorted by Oldest to youngest with all offspring sorted by youngest to oldest. That would make sense. LIS moved to a different family (I think in 1999), she appears in...

Are you able to help me with the final ordering required for, say, just the LB family, so that we see as per the Excel file I put in the drive? For the purposes of monitoring a family, a 'family book' is created for all living family members minus independent males and those that have moved to...

Thank you, a great explanation, bravo.

You are indeed a wizard - thank you so much! i have just scanned all queries and the final tree and all looks very good. The tree is phenomenal for visualization, you are right - how very exciting. Only one query that depends upon another absent: "qryPopThree" plus the qryPopTree report is...

Amazing this tree control.. did you create it? How very clever you are! Why isn't there one for Access? V excited to take a look at the queries too - thank you again!

Great Hmmmm, the code... which - from the amazing threads you sent and that I've tried to understand - you are evidently very brilliant at! Loved the tree views, with ability to collapse, expand etc. Very elegant. Ancient and all in a single table, but I believe robust enough. Thank you so...

Very determined! Thank you.. Yes, I believe that you could be on to the solution but there are some buts to follow... It may be that I need a query/queries to create 'generational levels' from the primary table? Re yr table below, remember kids order is youngest first, not oldest, and also...

Thank you MajP, yes, I'm aware of the importance of all of the above points. I did not design this database and things were v different 50 years ago. All MOTs relate to Casename, hence my self-join attempts that actually do pull everything out but I can't get the ordering according to...

Thank you v much MajP! I shall try these functions. Re. 'GMA', yes, as mentioned yesterday, GMA is incomplete because the data go so far back that when monitoring of pop started, GMAs weren't known. 'GMAFin' is the dummy GMA I assigned which uses the mother's name with a 'G' prefix, rather...

Perfect, yes! Correct again! Amazing thank you! I agree, if only I could get there.. How do I do that? Is your email address public somewhere? I can WeTransfer to your email address, if that works for you? Thank you!

Yes correct - as is your obs that all records in the first column are the top level. In answer to yr earlier Q, for better or worse, GMA field is known grandmothers, but sketchy n gappy because this was pre-47 yrs ago. Where there is no GMA, I created a dummy field 'GMAFin' (added 'G' prefix...

Many thx MajP, I can achieve this but as my latest post explains I can't just use the report output. The ordering needs to be according to the steps sent as attached PDF, where oldest female in family appears first, with her daughters and kids appearing in descending birth order, not ascending...

And I can achieve this, which shows max of 3 levels for this family, but I'm stumped as far as how to get the final ordering with a cool tree look like your stunning example.. MajP thank you. Yes, I would love a tree like yours, but the ordering is incorrect - my fault. Yes, you are right...

MajP, thank you for your time and patience first and foremost! Please find attached accdb containing a table and a query. I messed up my tree path query series, so only have a snapshot of partial dataset of a different family that I achieved with a union query and a subquery for each level...

MajP, forgive me, I forgot to extract qualifying males (sex =M) in the first sweep and only living family members that haven't joined another family. I will send you another dataset shortly for a different family (always made up of adult females and their offspring, adult males being independent...

Thank you so much for the quick replies Uncle Gizmo and MajP. I shall take a look at the thread you've suggested Uncle Gizmo, and many thx MajP. I'm so grateful and shall send one complete family, rather than the entire population, given that this will be the focus and has all of the...

Hello greater minds and I appreciate any help you can offer me.. .I'm desperate to resolve this after many diverse attempts. I have a population of animals in a single table each with a PK, a code for the individual family member (text) and a code for the mother (text). The mother code only is...

Dear All, I am new to this forum and hoping, after many attempts to get the code right, to find someone with the required expertise. I have a form with a button and 'on click' vba code for importing dbase files filtered by a parameter query. The routine to import works well, but only...