>Hi,
>
>I have a table that has a datetime field. The table contains numerous records.
>Is there a command or a function that I can use to convert all the seconds of the datetime fields to zero?
>
>example: 12/05/01 09:08:35 AM change to 12/05/01 09:08:00 AM
>
>any help will be greatly appreciated.
>
>Thanks in advance

Hi Mike,

See Sec() function.

Replace All Datetimefield With Datetimefield - SEC( Datetimefield )