[AccessD] Today's Stupid Question

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.