How do i reference fields from a query with two tables and field names are the same?

[SilverDevil72]

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)

[June7]

Could use alias names in query and refer to those with VBA then the table qualifiers would not be an issue.

Really should not use spaces nor punctuation/special characters in naming convention nor exact same field name in multiple tables.

Without spaces and special characters, brackets are not needed.
RS.("tablename.fieldname")
RS!tablename.fieldname
works

Including brackets as following work.
RS.("[tablename.fieldname]")
RS![tablename.fieldname]

[SilverDevil72]

June7, Many thanks for your response!! Modified query using Aliases. Problem solved. Again, many thanks!!