Help with a querry

R

Ron

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.
 
K

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())
 
Ô

ôë

Ken Snell said:
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>

Ron said:
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.
Click to expand...
Click to expand...
 
Top