Help with a querry

[Guest]

I have tables and queries with date due fields. I want to create a querry
that will tell me when something is due with in x number of days. I want a
pop up box to pop up and tell me to enter a number of days in it. Then the
querry will run and tell me what is then due in that many days. For example,
if I put in 30 days, that the querry will run and list all items due in 30
days. Can someone help me with this.

 

[Ken Snell [MVP]]

Use a query that has a criterion expression similar to the following for the
date field:

Between Date() And DateAdd("d", CLng([Enter the number of days:]), Date())

 

[ôë]

Use a query that has a criterion expression similar to the following for the
date field:

Between Date() And DateAdd("d", CLng([Enter the number of days:]), Date())


--

Ken Snell
<MS ACCESS MVP>

I have tables and queries with date due fields. I want to create a querry
that will tell me when something is due with in x number of days. I want a
pop up box to pop up and tell me to enter a number of days in it. Then the
querry will run and tell me what is then due in that many days. For example,
if I put in 30 days, that the querry will run and list all items due in 30
days. Can someone help me with this.