Forum Discussion
Link Rows within an Access Table or Query
Hi all I've googled to within an inch of my life, spoken to SQL and Power BI experts and Excel experts, and no-one can seem to help me building a code that will work in Microsoft Access VBA to ca...
i made a sample of what you requires.
on the demo, i am assuming Value is Numeric.
this will be save in primary_id in both primary and secondary table.
arnel_gp Hi! Thank you so much for trying to help! Unfortunately the Value Column doesn't contain the same value in the Primary and Secondary lines, so I'm looking add a field that creates that using a Module in Access, e.g., I'm trying to find a way to calculate the NEW CALCULATION column below in Access. The only way that we know that these fields are related is the order in which they appear (each Primary record has a "*" in the Value and the ones directly under it (until the next *) are the Secondary records. Does this make sense?