Wortz, Charles
CWortz at tea.state.tx.us
Mon May 12 14:27:01 CDT 2003
Frank, As I always told my students, the only stupid question is the unasked one. Now, show us how you are trying to do it and somebody on the list will be able to point you to a better, working solution. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Frank Tanner III [mailto:pctech at mybellybutton.com] Sent: Monday 2003 May 12 14:19 To: Database Advisors Subject: [AccessD] Today's Stupid Question And now for today's stupid question.... I am using Microsoft's DateTimePicker ActiveX control, because I am mot skilled enough to code my own caledaring and time system, and am running into some problems. I have one DTP (date time picker) in Calendar mode for start date, and one in clock mode for start time. I also have one for end date and time as well. Due to a limitation of the ActiveX components, I cannot directly access the info from my query, so I have to fill out "invisible" text boxes with the info. Now comes the problem.... The field I am comparing to is a datetime field in the following format: mm-dd hh:mm:ss. I am having no luck converting the two seperate date and time fields into a single field in order to compare it to this datetime field. Does anyone have any ideas on how I can do this? Any assistance you can give would be greatly appreciated.