Date Range Question

R

Raj

I am currently using BETWEEN function to enter a date range in a parameter
query. What I would like to know if it is possible to have the query pull
the date from a table? I would also like to know if it is possible to have a
parameter for a week 30 and have the query pull all data from that week?
Thanks in advance
Raj
 
K

KARL DEWEY

Sure. Create another field in the design view grid using the week function
and a criteria prompt. Do not forget the also prompt or build in criteria
for the year because it will pull all data with that week no matter what year.
 
R

Raj

Thank you

KARL DEWEY said:
Sure. Create another field in the design view grid using the week function
and a criteria prompt. Do not forget the also prompt or build in criteria
for the year because it will pull all data with that week no matter what year.
Click to expand...
 
Top