Access的sql不支持Cast 和Convert吗？
那我想将输入的字串转换为日期格式，sql语句如何写？
(类似Mssql用cast('2002-10-10' as datetime)的效果)
---------------------------------------------------------------
the Cast and Convert are not supported in Jet Sql
U can replace them with the functions like
datevalue('2002-10-10'),timevalue('02:02:02')
format (datecol,'YYYY-MM-DD')