add date to time value

S

smk23

I need an expression to add a date value to time value in a form control. The
backend is SQL server 2k. I have time values with the date value currently
1/1/1900 and want to replace the 1/1/1900 with a specific date value which is
the value of another control.

Thanks so much!!
 
O

Ofer

I'm not sure if you are trying to change the value of the field or just to
display the combination of the two fields in a form, you can try and use this

=DateFieldWithDate & " " & format(DateFieldWithTime,"hh:mm:ss")
 
S

smk23

Thanks Ofer!
I tried to put that in a query field and get a syntax error in the FROM
clause. ANy thoughts?
 
Top