Date Criteria

[beckie1234]

I have created a form that runs queries based on a begin date and an end date that the user enters into combo boxes (named begin and end). The name of the form is downtime graph. I want to use this code as the criteria in the queries so is reads the dates entered on the form, but it doesn't work. Any suggestions would greatly be appreciated.

> Forms![frmDownTimeGraph]![begin]
Forms![frmDownTimeGraph]![begin].AfterUpdate AND
< Forms![frmDownTimeGraph]![end]
Forms![frmDownTimeGraph]![end].AfterUpdate

 

[Wiz47]

I have created a form that runs queries based on a begin date and an end date that the user enters into combo boxes (named begin and end). The name of the form is downtime graph. I want to use this code as the criteria in the queries so is reads the dates entered on the form, but it doesn't work. Any suggestions would greatly be appreciated.

> Forms![frmDownTimeGraph]![begin]
Forms![frmDownTimeGraph]![begin].AfterUpdate AND
< Forms![frmDownTimeGraph]![end]
Forms![frmDownTimeGraph]![end].AfterUpdate

The following would include the beginning and ending Date and any Date between the two.

WHERE [YourTableFieldName] Between Forms!frmDownTimeGraph!begin And Forms!frmDownTimeGraph!end;

 

[beckie1234]

Worked wonderfully. Gave me the results I was looking for. Thank you.

 

[Wiz47]

Worked wonderfully. Gave me the results I was looking for. Thank you.

You're Welcome. Glad I could help.