Hi,
Struggling to think of a solution or find an answer to this one.
What I need is quite specific. I will have several columns for different records. For specific reasons I need to have several records that have the same data in all columns except 2. However to eliminate user error in forgetting to repeat the data over the different records (Because there will be a lot of records), I need a way that we can update one record and all the data (Minus 2 columns) copies to the next say 5 or 6 records down.
Is there a way I can do this in Access?
Thanks
Matt