Experts:
I need some assistance with, potentially, writing a module that scans through a number of fields and **synchronizes** values in the event either blank or inconsistent value appear for the same GROUP-ID number?
As a picture is worth a thousand words, I have attached two documents:
- Excel file… it shows the sample data “before” and “after” plus some additional information.
- Access file… it includes the following:
- Table “tblSampleTable” includes the BEFORE sample data
- Query “qry01_Concatenate_FirstThreeFields” … successfully handles the concatenation (based on module “mod_Concatenate”).
- Query “qry02_Concatenate_FirstThreeFields_PlusCity” … this is where I need some help with… once I throw additional fields into the query, my record count increased past four (4) records.
My question: Does anyone know of a function that “synchronizes” e.g., [Age] in the event any of the age values (for same GroupID) is either missing or is different than the other age values for the same GroupID?
Thank you for your help in advance,
EEH