Date Range Question

G

Guest

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
 
G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top