CODEWITHSUNDEEP
ms-access
J Casey
J Casey

Reputation: 1

Access Query Design View replicating criteria

I am working on a form based parameter query and it was working great until today when I had to add new fields into my base table and edit the form accordingly.

When I entered my query in design view to add the new code, the code I have in place the criteria has repeated itself hundreds of times down the criteria rows and is adding its own columns.

If I delete the excess rows and columns the form stops returning any results; and deleting and re-creating the query generates the same problem.

I've attached a screenshot for reference.

Thank in advance for the help.

Access Screen shot

Upvotes: 0

Views: 59

Answers (1)

J Casey
J Casey

Reputation: 1

This has been solved. I was able to find another example on another forum and moved the coding into the "Field" field on the query and added an additional tage.

Upvotes: 0

Related Questions