Formula

  • Thread starter Thread starter Kim
  • Start date Start date
K

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
 
Try:
< 60 Or > 61

If you want to include the records where the field is blank also, try:
< 60 Or > 61 Or Is Null
 
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
Click to expand...

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
 
Back
Top