Hi guys and gals
I'm trying to insert a date into a field in an Access table. This field is of the General Date type. I want the date to be entered as "dd/mm/yyyy hh:mm:ss" and this works fine until I try and enter the time part as 00:00:00 in which case the field only records the date part and not the time .
My question is how can I add "01/01/2002 00:00:00" and get the whole lot to be stored, not just the date part?
Thanks for any help