Update on same table with criteria on records
Posted on 2007-11-25
Hi, I would like to update a record (e.g.: record 3) on Access table with a criteria in another record (e.g. record 1).
So in this case, for a matching ID in A, with the STATUS "DEL", I will need to update the DOC field of both record 1 and record 3 to a new value "D", & copy the INFO field from record 1 (old data) to record 3 (new data).
UID - ID - STATUS - DOC - INFO
1 - A - APP - C - XXX
2 - B - APP - C - XXX
3 - A - DEL - NULL - NULL
4 - C - APP - C - XXX
5 - D - APP - C - XXX
Must it be done using 2 tables to compare?