<div>
<div class="content wysiwyg-content">
I have two tables appropriately linked: <br />
tblA<br />
EmpID<br />
Start<br />
End<br />
<br />
tblB<br />
EmpID<br />
1st_Start<br />
1st_End<br />
<br />
I need to copy data from tblA Start and End fields into tblB 1st_Start and 1st_End. &nbsp;<br />
tblA.Start = tblB.1st_Start and tblA.End = tblB.1st_End<br />
Not sure on syntax for this. &nbsp;Thanks
</div>
</div>


I have two tables appropriately linked: 
tblA
EmpID
Start
End

tblB
EmpID
1st_Start
1st_End

I need to copy data from tblA Start and End fields into tblB 1st_Start and 1st_End.  
tblA.Start = tblB.1st_Start and tblA.End = tblB.1st_End
Not sure on syntax for this.  Thanks

Copy data from one table to another

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.