Accepting between criteria from text box in access 2007

  • Thread starter Thread starter H0MELY
  • Start date Start date
H

H0MELY

I have prepared a tool in Access 2003 that allows me to pull data based upon
the data between two set dates [Start Date] and [End Date] that are
established from a form. In Access 2003 I have the criteria set as...

Between [Forms]![main_page]![Text_start_date] And
[Forms]![main_page]![Text_end_date]

In Access 2007...this criteria returns an empty set. Has anyone run accross
this before and if so, how did you get around it. Thank you in advance for
your time.

-john
 
A little extra information I just figured out...In 2007 the form created a
date picker...which when selected isn't actually entered until the focus is
moved off the text field...what was happening is the end_date was null.
Guess I should have looked at how the user was entering information. Thanks
for all of those who looked.

-john
 
Back
Top