I am using MS Sql Express as the backend database for a Microsoft Access
front end application.
I am using a calendar control to store the desired date in the sql datetime
field. The time portion of the field defaults to 12:00am.
What I want is to also store the time in the same datetime field as the
date, but I want to use a separate control from the calendar control. I.e. I
want the user to choose the date from the calendar control, then select the
time from a different control, but have both the date and time stored in the
single datetime field of the SQL database.
So far, I can't get the time to concatenate with the date properly.
Any ideas?
Thanks,
John Tindall