how to add days to calendar control value in query?

  • Thread starter Thread starter Daniel M
  • Start date Start date
D

Daniel M

I have a form that has a calendar control on it. I need to take the value in
that control and add 5 days to it in a query to do a between. Can someone
help?

something like select....where dateentered between calcontrol.value and
calcontrol.value+5
 
This should work:

....WHERE DateEntered Between [Forms].[YourFormName].[CalControl] and
([Forms].].[YourFormName].[CalControl] +5)

HTH,

Rob
 
Damn i was almost there. Worked great! thanks.

Rob Parker said:
This should work:

....WHERE DateEntered Between [Forms].[YourFormName].[CalControl] and
([Forms].].[YourFormName].[CalControl] +5)

HTH,

Rob


Daniel said:
I have a form that has a calendar control on it. I need to take the
value in that control and add 5 days to it in a query to do a
between. Can someone help?

something like select....where dateentered between calcontrol.value
and calcontrol.value+5
Click to expand...
Click to expand...
 
Back
Top