I have a form where I enter the Agent Name, Session Type, Start and End Dates. I’ve done this in the past but not with a Between statement and have not had a problem. I use the code below to put together a statement with the parameters I enter in the form.
I’m not a programmer so I’m not sure what the syntax problem is. I'm hoping someone can help me with this. Thanks in advance.
This is the error I am receiving...
3 results in 0.0047 seconds.
-
Syntax, Missing Operator
-
Syntax error (missing operator) in query expression...
Hi All,
I am getting the following MS Access error:
Syntax error (missing operator) in query expression '(((BOQ.Descrip tion) =Site Establishment Dismantle))'
For the following VBA statement:
...Code:Dim name As String name = "Site Establishment Dismantle" Set rs1 = db1.OpenRecordset("select BOQ.Description from BOQ where " & " (((BOQ.Description) =" -
Syntac error (missing operator)
Hi - I can get this to work in SQL Server - but when also trying to make
the application compatible with MS Access I get an error:
Select tblfaqnetgroups .group_name from tblfaqnetroles
Inner Join tblfaqnetgroups ON tblfaqnetroles. group_id =
tblfaqnetgroups .group_id
Inner Join tblaccess ON tblfaqnetroles. user_id = tblaccess.user_ id
AND tblaccess.user_ id = 1
The error in Access is:
...
