>When I insert a DATETIME() into a record, I don't want it to put in the seconds. I have SET SECONDS OFF, but it still records the seconds. How can I make it just leave the seconds at 0?
>
>Thanks,
>
>Michelle

You can't, the seconds is part of the datetime. SET SECONDS only affects the display of the datetime.