No data Returned with criteria from Calendar Control (1 Viewer)

weilerdo

Registered User.
Local time
Today, 08:49
Joined
Apr 21, 2005
Messages
109
Hi All. I have a query that is based on 1 table. I am using a form with a calendar control for the users to select the date range. In my table the date format is mm/dd/yyyy. My calendar control is pulling the date format mm/dd/yyyy I need my query to only look at the mm/dd part of the field. In my criteria field inc_date I have Between [Forms]![frm_LookUpEnquiry]![txtSelectDate] And [Forms]![frm_LookUpEnquiry]![txtDate2] I have tried the datepart but Im not sure I am doing it right. Basicly Im not sure how to parse out the date to only look at the mm/dd. Or would this be better done in a SQL query Any Idea's for this would be very appreciated. Im kinda in a bind on this one and its the last thing I have to do to finish this database.

Thanks for all you assitance in advance
 

MStef

Registered User.
Local time
Today, 12:49
Joined
Oct 28, 2004
Messages
2,251
Hello welierdo!

Look at "DemoMMDDA2000.mdb",
Open form1 and try.
 

Attachments

  • DemoMMDDA2000.zip
    11.4 KB · Views: 107

Users who are viewing this thread

Top Bottom