Less than Or Equal

[bladelock]

I am trying to write a query that will substract two dates from one another
and display only the results of "Less Than Or Equal to 1"

Here is what I have so far:

SELECT DenialNumbers.ID, [discharge]-[admission] AS EqualOrLessThanOne
FROM DenialNumbers;

I just want to display the records that are less than or equal to one. This
query display all records with many numbers.
Thanks

 

[KARL DEWEY]

Try this --
SELECT DenialNumbers.ID, [discharge]-[admission] AS EqualOrLessThanOne
FROM DenialNumbers
WHERE ([discharge]-[admission] <=1);

 

[bladelock]

Thanks

Try this --
SELECT DenialNumbers.ID, [discharge]-[admission] AS EqualOrLessThanOne
FROM DenialNumbers
WHERE ([discharge]-[admission] <=1);

--
KARL DEWEY
Build a little - Test a little

I am trying to write a query that will substract two dates from one another
and display only the results of "Less Than Or Equal to 1"

Here is what I have so far:

SELECT DenialNumbers.ID, [discharge]-[admission] AS EqualOrLessThanOne
FROM DenialNumbers;

I just want to display the records that are less than or equal to one. This
query display all records with many numbers.
Thanks