Date Query

[Rhonda]

I am creating a very Simple database that allows users to clock in and out to
validate the shift they are working. How do I create a query to run on a
select date... I need to allow the user to enter the Date span

 

[SAm]

are you using a form? if so, do you have two text boxes one for begindate and
one for enddate? what type of query are you trying to run? what are the
fields in your table? there is not enough information here.
sam

 

[John Vinson]

I am creating a very Simple database that allows users to clock in and out to
validate the shift they are working. How do I create a query to run on a
select date... I need to allow the user to enter the Date span

Create a Query with a criterion of

= CDate([Enter start date:]) AND < DateAdd("d", 1, [Enter end date:])

John W. Vinson[MVP]