Bigbadborris
Active member
- Joined
- Aug 21, 2013
- Messages
- 35
- Programming Experience
- Beginner
Hi all
I have an access database which has 2 tables (IntContactsKnown & IntContactsUnKnown). Each of these has a field called KnownUnknown. When the Contact becomes Known a 1 is put in this field. I would like the program to read the data in IntContactsUnKnown and copy all the rows which have a 1 in the KnownUnknown field and paste them into the table IntContactsKnown. Then it should delete those records from IntContactsUnKnown.
Any help would be most appreciated
Many Thanks in advance
I have an access database which has 2 tables (IntContactsKnown & IntContactsUnKnown). Each of these has a field called KnownUnknown. When the Contact becomes Known a 1 is put in this field. I would like the program to read the data in IntContactsUnKnown and copy all the rows which have a 1 in the KnownUnknown field and paste them into the table IntContactsKnown. Then it should delete those records from IntContactsUnKnown.
Any help would be most appreciated
Many Thanks in advance