I am rubbish at access but seem to be pushed into it on many occassions as I am able to turn a computer on.
How would I update the contents of one record in a table to another record in the same table. Before you rush a reply and say an update query ( if thats what you were going to say ), please read on
I have a table that has 2 pieces of information that I need to merge. The problem is eg (client id number 1, report number 1) has information in it and (client id number one report number 2) would like to have that informatiion. I have set up querys for [Master report] which filters report 1 and another [master update] which filters report 2. I have tried to run an update query on [master report] to influence [master update] but it does not seem to work, at best it warns me its going to update but does nothing. Im now guessing that I cannot update 1 query from another. disregarding queries as Im not sure im on the right track anyway, how would you guys do this ?. Im running access 2010 office