I need to append records 11709-13847 of the field "Main_id" in my "FISHSRY_SCCT_MAIN" table to records 1-2139 (of Barrier_id) in another table(FISHSRY_SCCT_BARRIERS).
I don't want to simply add on the records from "Main_id" to the end of the barriers table.
How can I do this? I know I need to use an update query (?) but can't get the syntax/logic right. Would it be possible for you to show me the exact sql commands to use? This is my first time doing an update query using criteria expressions and I'm confused.
The reason I want to do this is because the records in the Barriers table link to records in the Main table - they are linked by the "Main_id" field.
sorry rudy, wrong terminolgy - i mean update (not append)
I have an empty field in my barrier table: Main_id. I would like to add to this empty field the records from the main_id field in the main table that related to the barriers table. (main_id records 11709-13847)
This is a little example of how I would like it to look in the end:
are these just sequential numbers you want assigned? Yes, basically. I could type them in one by one, starting at 11709 and going till 13847 - but that probably wouldn't be alot of fun. Is there a less time consuming way to do this?
I will trying explaining my problem from a different angle again in the morning.
Hi, I would like the update the blank records in a field, but with sequential numbers, from 13-2141. (ie: the first blank record would be updated with the number 13 and the last blank record with the number 2141)
How can I change the following sql stament to get the results I want:
The amount of blank records is the exact amount of records i want to update. (2139)
UPDATE FISHSRY_SCCT_MAIN SET FISHSRY_SCCT_MAIN.Meta_data_ID = "meta_data_id +12"
WHERE (((FISHSRY_SCCT_MAIN.Meta_data_ID)=0 Or (FISHSRY_SCCT_MAIN.Meta_data_ID) Is Null));