By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Syntax error (Missing Operator) in query expression

P: 31
I am getting this error:
Syntax error (Missing Operator) in query expression '[Project] =ZYZ Project'

My code is:
intProjectEstimate = DSum("LumpSum", "tblProjEstimateLumpSum", "[Project] =" & Me.cboProject & "")

I have tried various combinations of double and single quotes without success.

Can anyone shed some light please?

Many thanks
Dec 18 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Assuming that Project is text, I believe you'll find that

"[Project] =" & Me.cboProject & "")

needs to be

"[Project] ='" & Me.cboProject & "'")


Linq ;0)>
Dec 18 '08 #2

P: 31
Thanks Linq ;0)>

That did the trick!

Actually, I thought I had tried that at some stage but it did not work before. Obviously, I mistyped something!
Dec 18 '08 #3

NeoPa
Expert Mod 15k+
P: 31,419
@OzNet
Quoting the error message like that made the answer a doddle (especially for one of Linq's calibre). I just wanted to draw attention to how much easier you made this than many do :)
Dec 23 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.