how to add days to calendar control value in query?

[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

 

[Rob Parker]

This should work:

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

HTH,

Rob

 

[Daniel M]

Damn i was almost there. Worked great! thanks.

This should work:

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

HTH,

Rob

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