Objective: Using the Prod file as the master to match to the BOB file. Then because there are duplicates, update with an update sql call, update the BOBTest.[Volume & page #] field to make it unique from other records in the table. Having trouble accessing the fields after the query. Query works fine but i can't access the fields.
Have tried numerous solutions to no avail. I am really stuck. Please help!!
For example;
RS!Fields([BOBTest].[Volume & page #]) Tried varies "Field" connotations.
RS.([BOBTest].[Volume & page #])
RS.[BOBTest].[Volume & page #]
RS.[Volume & page #]
Searched a lot but no satisfactory answer. Maybe querydef but i don't understand how to use it. I need clear example accessing the fields.
Please help!!
/ Code
Select statement:
QRS = "SELECT [Prod File].[Volume & page #], BOBTest.[Volume & page #]
FROM [Prod File], BOBTest
WHERE ((([Prod File].[Abstract Bk # & Pg])=BOBTest.[Abstract Bk # & Pg]) And (([Prod File].[Volume & page #])=BOBTest.[Volume & page #]));
Set RS = db.OpenRecordset(QRS, dbOpenDynaset, dbPessimistic)