Less than Or Equal

  • Thread starter Thread starter bladelock
  • Start date Start date
B

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
 
Try this --
SELECT DenialNumbers.ID, [discharge]-[admission] AS EqualOrLessThanOne
FROM DenialNumbers
WHERE ([discharge]-[admission] <=1);
 
Thanks

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

--
KARL DEWEY
Build a little - Test a little


bladelock said:
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
Click to expand...
Click to expand...
 
Back
Top