Criteria

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.
 
T

Tom Ellison

Dear Loi:

I would recommend:

NOT IN(2, 4, 5, 6)

to do what you suggest.

Tom Ellison
Microsoft Access MVP
 
P

PC Datasheet

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.
 
M

Marshall Barton

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.
 
T

Tom Ellison

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

Tom Ellison
Microsoft Access MVP
 
M

Marshall Barton

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...
 
T

Tom Ellison

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