I am getting this error message please help

[CRobledo]

I'm getting this error message on a form I'm making. Syntax error (missing operator ) in query expression SELECT Sum( [Orchardinfo]![Acres] ) WHERE [Orchardinfo]![UnboundOrchard] = [Workorder Input]![Grower] AND [Orchardinfo]![UnboundBlock] IN [Workorder Input]![Block2]



does anyone see anything I did wrong?

[andy49]

I'm no expert on sql but thought in had to be followed by a list.


Sent from my iPhone using Tapatalk

[pbaldy]

There's also no FROM clause in what's shown. More detail might help; the full SQL or code.

[CRobledo]

I made a form with a combo box that stores multiple values and those values are the names of small pieces of land in a large property(orchards). It gets those names from a table call Orchardinfo. What I would like it to do is sum the acres for each land to give me a total acres selected.

here is the table it looks at and at the end I want it to store the data in a table called work order input which is the control source for the form.

[pbaldy]

If Block is a multi-value field, I'm not sure how to use it. I haven't and won't use one. I don't think it does what you think, but if you want to attach the db here I can play with it.

[CRobledo]

https://www.dropbox.com/sh/9olwhaonr...L28ZnJQya?dl=0

I could not find how to do an attachment so I just did a link

thank you so much! I've been trying to figure this out for days
the pop up form that opens when you first open the DB you can right click and close.

[NTC]

Sorry I do not open attachments. Generic advice: do not rely on the form's fields for the math you seek. The form is the presentation level and while sometimes is suitable to provide the input to math - not always - and in your case because block is multi value and acres further splits block into sub values you need to address your math at the query level. Then at the form level do a DLookUp of the query result.