Search results

Thanks for the suggestions, however your solutions involve using VBA code which I'm attempting to avoid. I was hoping to achieve the data conversion using SQL code only. I think I could do this in Sybase/Oracle but I'm beginning to think the Jet engine can't do it.

IN Access 2000 I want to compose an SQL statement to create a new table from an existing one. I want to select a datetime field from the existing table and insert it as a text string in the new table. Is there some kind of SQL conversion function I can use in the SELECT statement to achieve...