Date Range Question

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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...
 

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

Similar Threads

Date and Parameter question. 4
Duplicate prompts in crosstab query and subsequent report 1
Date Range in Query using DateAdd 4
Date Range Pulling Only Month 1
Date Range 1
Parameter Queries in Crosstab Query 2
query to pull between two dates 4
Query between date range 2

Back
Top