[AccessD] Today's Stupid Question

Frank,

Convert the individual date and time values to strings, then
concactenate them together, and convert the resulting string back into a
date using the CDate() function.

That's where I'd start, anyway.

Seth

On Mon, 2003-05-12 at 14:19, Frank Tanner III wrote:
> 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.

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University