Criteria

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
I created a report and I want it not show #2, 4, 5 and 6.

Ex: The report has ID field: 1,2,3,4,5,6,7,8,9 and 10.

ID
1
2
3
4
5
6
7
8
9
10
In criteria line, I typed: Not 1. It did not show #1. It
is good.
 
Dear Loi:

I would recommend:

NOT IN(2, 4, 5, 6)

to do what you suggest.

Tom Ellison
Microsoft Access MVP
 
In the first row of the criteria enter Not 2. In the second row, Not 4, in
the third row, Not 5 and in the fourth row, Not 6.
 
PC said:
In the first row of the criteria enter Not 2. In the second row, Not 4, in
the third row, Not 5 and in the fourth row, Not 6.
Click to expand...


Come on Steve, that's quananteed to always match any value
(except Null). It needs AND between the terms (per Rick's
post), not OR.

Personally, I think Tom's reply is the cleanest way to
express this criteria.
 
It must have been a good reply. Marsh doesn't make a habit of agreeing with
me! <g>

Tom Ellison
Microsoft Access MVP
 
Aw gee, Tom, now I do have to disagree ;-)

Actually, I do agree with you much of the time. I just
don't work in an environment where I can practice what you
preach ;-))
--
Marsh
MVP [MS Access]



Tom said:
It must have been a good reply. Marsh doesn't make a habit of agreeing with
me! <g>

Tom Ellison
Microsoft Access MVP


"Marshall Barton" wrote [snip]
Personally, I think Tom's reply is the cleanest way to
express this criteria.
Click to expand...
Click to expand...
 
You wouldn't be nearly such a friend if you didn't have your own valuable
opinions and creative ideas to add. I wouldn't change a thing!

While it's pleasing to have you agree, it's usually more valuable when you
don't.

Tom


Marshall Barton said:
Aw gee, Tom, now I do have to disagree ;-)

Actually, I do agree with you much of the time. I just
don't work in an environment where I can practice what you
preach ;-))
--
Marsh
MVP [MS Access]



Tom said:
It must have been a good reply. Marsh doesn't make a habit of agreeing
with
me! <g>

Tom Ellison
Microsoft Access MVP


"Marshall Barton" wrote [snip]
Personally, I think Tom's reply is the cleanest way to
express this criteria.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top