Formula

[Kim]

I am using 2000 Access.

I created a query for a report. I have a field [Status]
with code numbers in it. I do not want records with a
code of 60 or 61. I tried "<>60" and that worked, but
when I tried to add the 2nd code - "<>60 or <>61" this did
not work. I also tried "<>60;61" but this did not work
either. Can anyone tell me how to eliminate these two
codes (and possibly more codes) from the report?

Kim

 

[Allen Browne]

Try:
< 60 Or > 61

If you want to include the records where the field is blank also, try:
< 60 Or > 61 Or Is Null

 

[fredg]

I am using 2000 Access.

I created a query for a report. I have a field [Status]
with code numbers in it. I do not want records with a
code of 60 or 61. I tried "<>60" and that worked, but
when I tried to add the 2nd code - "<>60 or <>61" this did
not work. I also tried "<>60;61" but this did not work
either. Can anyone tell me how to eliminate these two
codes (and possibly more codes) from the report?

Kim

It probably didn't work because you didn't repeat the criteria field
name for each criteria, and I think you want AND, not OR:

Where [Status] <> 60 and [Status] <> 61