Query Criteria

  • Thread starter Thread starter JChick
  • Start date Start date
J

JChick

I am trying to exclude certain "Policy #s" on a query but
only the first policy listed is excluded. What needs to be
changed on the query to make sure all policies listed on
the criteria are excluded?
 
I am trying to exclude certain "Policy #s" on a query but
only the first policy listed is excluded. What needs to be
changed on the query to make sure all policies listed on
the criteria are excluded?
Click to expand...

Since you didn't choose to tell us what the query now contains, it's
more than a bit difficult to tell you what to change!

But, consider using a syntax like

NOT IN ("123454X", "123554Y", "112233Z")

as a criterion on the Policy.
 
Back
Top