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!
copying contents of one field to another [duplicating]
- Thread starter pam0566
- Start date
wazz
Super Moderator
- Local time
- Tomorrow, 00:16
- Joined
- Jun 29, 2004
- Messages
- 1,702
should be doable. work with a copy of the table. use the query builder and make sure you're doing an update query not append. (if i understand you want to fix existing rows, not add rows, so, update not append).
put the tables you need into the query grid and fool with it - as a SELECT query - until you get what looks right. change the type of query to update. you'll still need your criteria and you will probably have fill in the criteria "by hand."
if i'm not mistaken you can view the results of an update query (maybe it's append?) without actually running it. very useful!
not sure about your criteria as it is now. if you have [EQUIP.vehicleid]=[VehicleInfo.vehicleid] but you need to populate [vehicleinfo.vehicleid] ...sounds like something has to change slightly.
put the tables you need into the query grid and fool with it - as a SELECT query - until you get what looks right. change the type of query to update. you'll still need your criteria and you will probably have fill in the criteria "by hand."
if i'm not mistaken you can view the results of an update query (maybe it's append?) without actually running it. very useful!
not sure about your criteria as it is now. if you have [EQUIP.vehicleid]=[VehicleInfo.vehicleid] but you need to populate [vehicleinfo.vehicleid] ...sounds like something has to change slightly.
Last edited:
