I have an Access database which users update & access information from a web page using mssql code I've created.

I have 2 fields in a form that are of Date/Time format, but I only want them to enter a Time (HH:MMS), and this is creating a problem where it returns an error of Syntax Error in INSERT INTO Statement.

I know how to format the data when I'm retrieving the data to post it to the site, but Is there a way to format a SQL Insert Into Statement to properly insert this data and allow it to be used in future queries?

Thanks