[AccessD] Today's Stupid Question

Assuming the time value does NOT include a date, just add the date value
and the time value. 

Charlotte Foust

-----Original Message-----
From: Frank Tanner III [mailto:pctech at mybellybutton.com] 
Sent: Monday, May 12, 2003 11:19 AM
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.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com