date range in a query


B

blake7

Hi, I have a simple query that requires the user to input a date when
prompted, this then pulls records back from a table depending on this date,
in my query I have the following code [enter the date] as the criteria. My
question is can the criteria be changed so that when the user clicks on the
form to run the query it automatically returns all records from the actual
date (todays date) and seven days previous ?
Thanks All
 
Ad

Advertisements

F

fredg

Hi, I have a simple query that requires the user to input a date when
prompted, this then pulls records back from a table depending on this date,
in my query I have the following code [enter the date] as the criteria. My
question is can the criteria be changed so that when the user clicks on the
form to run the query it automatically returns all records from the actual
date (todays date) and seven days previous ?
Thanks All

Between Date() and Date()-7
 
Ad

Advertisements

B

blake7

Thanks fredg, works great
Regards
blake7

fredg said:
Hi, I have a simple query that requires the user to input a date when
prompted, this then pulls records back from a table depending on this date,
in my query I have the following code [enter the date] as the criteria. My
question is can the criteria be changed so that when the user clicks on the
form to run the query it automatically returns all records from the actual
date (todays date) and seven days previous ?
Thanks All

Between Date() and Date()-7
 

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