All Records <1 & 1>

W

Wayne-I-M

Hi Bob

I must be misunderstanding what you are trying to

All records plus 1 will give you all records in the table - so will all
records minus 1

Can you give more details of what you are trying to do
 
B

Bob V

What would I have in the query for all records plus1 and and all records
minus1
Thanks for any help................Bob
 
W

Wayne-I-M

Hi Bob

I'm still lost with this. You can put >0 in the crieria row in the query.
 
J

JK

Hi Bob,

If you are talking about a crteria in a query:

1 or -1

Not sure if that wat you wanted

Regards/Jacob

|
|
| What would I have in the query for all records plus1 and and all records
| minus1
| Thanks for any help................Bob
|
|
 
B

Bob V

Maybe <-1 & 1> .....Bob

Wayne-I-M said:
Hi Bob

I must be misunderstanding what you are trying to

All records plus 1 will give you all records in the table - so will all
records minus 1

Can you give more details of what you are trying to do
Click to expand...
 
J

John W. Vinson

What would I have in the query for all records plus1 and and all records
minus1
Thanks for any help................Bob
Click to expand...

If you want all nonzero records use

<> 0

as a criterion.

If you want all records execpt those with -1, 0 or 1 in the field, use
1 OR < -1
Click to expand...


John W. Vinson [MVP]
 
B

Bob V

Thanks Jk, Criteria was anything but nothing between -1 and 1
How would I write that?
Thanks Bob
 
J

JK

Hi Bob,

In the criteria line :
<-1 or >1 or
Not between -1 And 1 (I haven't tried it but I think this will work too)

Regards/Jacob


| Thanks Jk, Criteria was anything but nothing between -1 and 1
| How would I write that?
| Thanks Bob
|
| | > Hi Bob,
| >
| > If you are talking about a crteria in a query:
| >
| > 1 or -1
| >
| > Not sure if that wat you wanted
| >
| > Regards/Jacob
| >
| > | > |
| > |
| > | What would I have in the query for all records plus1 and and all
records
| > | minus1
| > | Thanks for any help................Bob
| > |
| > |
| >
| >
|
|
 
B

Bob V

John still showed this -0.0015.....Regards Bob

John W. Vinson said:
If you want all nonzero records use

<> 0

as a criterion.

If you want all records execpt those with -1, 0 or 1 in the field, use



John W. Vinson [MVP]
Click to expand...
 
J

John W. Vinson

John still showed this -0.0015.....Regards Bob
Click to expand...

That's correct. -0.0015 is greater than -1, and it's less than 1. Access is
giving you exactly what you are asking for.

All numbers from -0.999999999999999 to +0.9999999999999 (to about 14 decimals)
will pass the criterion
-1 AND < 1
Click to expand...


John W. Vinson [MVP]
 
Top