Query criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
= [Enter start date:] AND < DateAdd("d", 8, [Enter start date:])
Click to expand...

John W. Vinson[MVP]
 
Thanks very much!

John Vinson said:
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
Click to expand...
= [Enter start date:] AND < DateAdd("d", 8, [Enter start date:])
Click to expand...

John W. Vinson[MVP]
Click to expand...
 
Back
Top