date range in a query

  • Thread starter Thread starter blake7
  • Start date Start date
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
 
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
Click to expand...

Between Date() and Date()-7
 
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
Click to expand...

Between Date() and Date()-7
Click to expand...
 
Back
Top