I’m struggling with a query. I need to copy some data from a similar table (unused) into a current (in use) table. I need two fields worth of data, and I specifically need them to get the info relative to the current ID.
I have been trying to write a dynamic update statement, but keep getting stuck. The field names are the same in both tables, and the ID’s match exactly between tables.
Any ideas?