Hi All, I have a field in my table that is formatted as a Long Date (1/20/2006 12:00am) for example. I am using a form for my query paramters. My selection criteria is:
Between [forms]![formname]![calendarstart] and [forms]![formname]![calendarstop] This isn't working with my Long date field, but if I move the criteria to a field that is formatted as a short date, it works without a hitch. Any idea's???? ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
