date range in a query

[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

 

[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

 

[blake7]

Thanks fredg, works great
Regards
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

Between Date() and Date()-7