How to calculate a period of time

Hi, I really need some help on this one, I cannot seem to
be able to get it right.

I have this query which returns dates when an inspection
is due called [InspectionDue]. I have put this criteria
beneath it: =Date()+30. The only problem is that it
returns all dates after today's date and all I really want
is any date equal or after today's date within the next 30
days, not beyond the 30 days limit. Is there a way to do
this right?

Please help.
Thanks,

BETWEEN Date() AND Date()+30

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"AmandaP" wrote in message
...
Hi, I really need some help on this one, I cannot seem to
be able to get it right.

I have this query which returns dates when an inspection
is due called [InspectionDue]. I have put this criteria
beneath it: =Date()+30. The only problem is that it
returns all dates after today's date and all I really want
is any date equal or after today's date within the next 30
days, not beyond the 30 days limit. Is there a way to do
this right?

Please help.
Thanks,

Thanks Roger,

It worked!
Brilliant.

-----Original Message-----
BETWEEN Date() AND Date()+30

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"AmandaP" wrote in
message
...
Hi, I really need some help on this one, I cannot seem
to
be able to get it right.

I have this query which returns dates when an inspection
is due called [InspectionDue]. I have put this criteria
beneath it: =Date()+30. The only problem is that it
returns all dates after today's date and all I really
want
is any date equal or after today's date within the next
30
days, not beyond the 30 days limit. Is there a way to do
this right?

Please help.
Thanks,



.