Query criteria

[Guest]

I have a query that i need to select records which fall between a 7 day frame.
I know how to have the criteria prompt the user to enter a start and end
date ( >=[enter start date] and <= [enter end date]) however I'd like the
user to be able to pick a start date based on another table/query which will
include that 7 day period.

Thanks in advance

Shawna Roe

 

[John Vinson]

I have a query that i need to select records which fall between a 7 day frame.
I know how to have the criteria prompt the user to enter a start and end
date ( >=[enter start date] and <= [enter end date]) however I'd like the
user to be able to pick a start date based on another table/query which will
include that 7 day period.

Thanks in advance

Shawna Roe

= [Enter start date:] AND < DateAdd("d", 8, [Enter start date:])

John W. Vinson[MVP]

 

[Guest]

Thanks very much!

I have a query that i need to select records which fall between a 7 day frame.
I know how to have the criteria prompt the user to enter a start and end
date ( >=[enter start date] and <= [enter end date]) however I'd like the
user to be able to pick a start date based on another table/query which will
include that 7 day period.

Thanks in advance

Shawna Roe

= [Enter start date:] AND < DateAdd("d", 8, [Enter start date:])

John W. Vinson[MVP]