I am getting the following MS Access error:
Syntax error (missing operator) in query expression '(((BOQ.Description) =Site Establishment Dismantle))'
For the following VBA statement:
Dim name As String
name = "Site Establishment Dismantle"
Set rs1 = db1.OpenRecordset("select BOQ.Description from BOQ where " & " (((BOQ.Description) =" & Qu & name & Qu & "))", DB_OPEN_DYNASET)
The statement is in one line.
BOQ is a Table and Description is a Text Field Name.
I would like to select the record in the table that matches name string and then be able to access other field names of that record.
My alternative is using a do loop to search through the entire table...I would like to cut down on this wasted cpu overhead...
I am obviously doing something wrong. Please can anyone help?