Complex Query Again

[Anthony]

Ok, I have a table that has a device name, par, and current I only want it to
show devices that have 3 or less off of the current qty from the par. Can I
do this in access with a query?

Thanks

 

[John Spencer]

Perhaps. I find your question a bit vague, but I think what you want is the
following

SELECT *
FROM YourTable
WHERE [Par]-[Current] Between -3 and 3

OR

SELECT *
FROM YourTable
WHERE Abs([Par]-[Current]) <= 3

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Anthony]

Thanks for everyone's help.

Perhaps. I find your question a bit vague, but I think what you want is the
following

SELECT *
FROM YourTable
WHERE [Par]-[Current] Between -3 and 3

OR

SELECT *
FROM YourTable
WHERE Abs([Par]-[Current]) <= 3

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Ok, I have a table that has a device name, par, and current I only want it to
show devices that have 3 or less off of the current qty from the par. Can I
do this in access with a query?

Thanks