Query Statement For Dates

  • Thread starter Thread starter JCrowe
  • Start date Start date
J

JCrowe

I lost my old query statements example book and cant seem
to remember how to query dates in a time specific time
period on the fly.

Here is what I am trying to accomplish:
Using Access 2000. When I run my query I want a box to pop
up that required me to input the Start Date and when
entered it pops up the End Date box.

I am using the this statement to request "resources" for
the resources column and it cause a box to pop up for
input.

Like [Enter Resource Name (Leave Blank For All)] & "*"

Thanks,
JCrowe
 
In the criteria row of the DateField column in your QueryGrid, use:

BETWEEN [Enter Start Date:] AND [Enter End Date:]
 
Van,
Thank you for the help !

Van T. Dinh said:
In the criteria row of the DateField column in your QueryGrid, use:

BETWEEN [Enter Start Date:] AND [Enter End Date:]

--
HTH
Van T. Dinh
MVP (Access)



JCrowe said:
I lost my old query statements example book and cant seem
to remember how to query dates in a time specific time
period on the fly.

Here is what I am trying to accomplish:
Using Access 2000. When I run my query I want a box to pop
up that required me to input the Start Date and when
entered it pops up the End Date box.

I am using the this statement to request "resources" for
the resources column and it cause a box to pop up for
input.

Like [Enter Resource Name (Leave Blank For All)] & "*"

Thanks,
JCrowe
Click to expand...
Click to expand...
 
Back
Top