Register to reply

Moving records between tables in MS Access

by adjacent
Tags: access, moving, records, tables
Share this thread:
adjacent
#1
Jul7-14, 01:09 PM
PF Gold
adjacent's Avatar
P: 1,458
I have two tables(a and b) in one access document. And in each table, I have a field[called status](look up field) having the options "Done" and "Done_s".
What I want to do is move the records having the [status] "Done_s" to b. This should be done whenever the change occurs. Is this possible?

I never used access before and google also does not provide an answer to this.
Phys.Org News Partner Science news on Phys.org
New model helps explain how provisions promote or reduce wildlife disease
Stress can make hard-working mongooses less likely to help in the future
Grammatical habits in written English reveal linguistic features of non-native speakers' languages
256bits
#2
Jul8-14, 02:33 PM
P: 1,409
You can use the built in Microsoft Visual Basic.
Lesson 1, what better place to start.
http://www.functionx.com/vbaccess/index.htm


Register to reply

Related Discussions
Records and C++ Engineering, Comp Sci, & Technology Homework 3
Compare and/or combine two Access database tables Computers 5
Academic Records, Expunged Academic Guidance 6
Fortran: help with I/O in Direct Access and Seq. access Programming & Computer Science 0
Filtering/Displaying records from Access in Visual Studio 2008 Programming & Computer Science 1