Query for upcoming expiration date

[jones]

Hi Everyone,

Please somebody could help me.

i'm just starting to use an access 2007. My problem is i have table filled with names and expiration of visas(date field), i want my database to show me if there are upcoming expired visas 3 months before its due.

i try to make it in a simple query/ criteria : Between =Date() + 90 And =Date()+100
so that it will show me all upcoming expired visas from today's date before 3 months its due and for 10 days will still show up because if im not around for 3days i can still see the names when i came back. Nothing comes up.



Thank you in advance.

[June7]

Don't you want all non-renewed visas already expired and those that will expire sometime in the next 90 days?

<= Date() + 90

[jones]

Thank you very much Sir,

It works.