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" <(E-Mail Removed)> wrote in message
news:1343101c443dc$f06b3380$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
message
>news:1343101c443dc$f06b3380$(E-Mail Removed)...
>> 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,
>>
>
>
>.
>