copying contents of one field to another [duplicating]

[pam0566]

I have an old data base, with 98k records, and am designing a new front end. I have had to add one field. now i have 98k of records that are missing this one field. if i import, it doesnt append to fill in that field, and i cant copy one column and paste to other like i thought i could. (think i did this once before, but 2 columns were part of same table, these are 2 different tables, so assumin that is the difference. Is there a way to write a query where [EQUIP.vehicleid]=[VehicleInfo.vehicleid] to do a one time population of field [vehicleinfo.vehicleid]. Since these 2 tables are related, its a necessety. I tried to add just that into a query, but it produces no results... Any advice greatly appreciated!

 

[sbenj69]

I would just do an update query. For an example on how to do this, I posted a sample db here: http://www.access-programmers.co.uk/forums/showthread.php?t=153950