Eliminating data from a report

  • Thread starter Thread starter Hazel
  • Start date Start date
H

Hazel

I have not used Access in a while but when doing a query
today for a report, I tried to put in an expression that
would eliminate two separate listings in a field. The
expressions I used in the query were <> "Commissioners"
and underneath in the line marked "or" I entered <>"Board
of Education". As long as I only entered one line it
worked. When I entered both expressions, it did not
eliminate either.
 
Hazel said:
I have not used Access in a while but when doing a query
today for a report, I tried to put in an expression that
would eliminate two separate listings in a field. The
expressions I used in the query were <> "Commissioners"
and underneath in the line marked "or" I entered <>"Board
of Education". As long as I only entered one line it
worked. When I entered both expressions, it did not
eliminate either.
Click to expand...

Think about it some more. You should be using AND, not OR.

You're currently saying if the value is not "Commissioners" OR not "Board of
Education" then include it in the results. A record with "Commissioners" will be
included because it is not equal to "Board of Education" and a record with "Board of
Education" will be included because it is not equal to "Commissioners".
 
Back
Top