Please help me with date criteria .....

[elsiegee1]

Hi all,
I have a field in my database which shows the last date of review for clients. I have a query from this which shows any reviews which are overdue - they have to be completed every 6 months, so I use

<Date()-180 Or Is Null

The thing is, now we need a query to show clients whose review WILL be overdue in the following month from a date that we enter. e.g, if we enter 1/06/07, we want to see everything that will become overdue in the month of June.

Can anybody help me with the criteria I need to enter in a query to get this result?
Thanks for any help
elsiegee

 

[MStef]

Look at "DemoDateOverdueA2000.mdb".
Look at Table1, Query1, Form1.
Open Form1 and try.
Adapt it as you need.