Correct Quarrie Syntax Question (1 Viewer)

[marseneault]

Which field do I put the query in?
When i put it in the ContractorName field, it gives me the same error as before:

You have written a sub query that can return more than one field without using the Exists reserved word in the main query's From clause. Revise the SELECT statement of the sub query to request only one field.

 

[plog]

There should be no sub query.

You were buidling 2 queries--one in the design view one in the expression builder. Take the one out of the expression builder and put it in a new query design view.

 

[marseneault]

So I have a new query in design view. I add the Tables That I want, then I add the fields that I need.
Next, I know that I need to paste the Expression that I built in the Expression builder. I put my curser in the Criteria row of the first Field (Named ContractorName) I then get the same warning that I have had about there being multiple results in a subquery

 

[plog]

I know that I need to paste the Expression that I built in the Expression builde

100% wrong. Throw that bad code away. Rebuild it, don't recopy it.