Table update says must use updateable query.

[mutley1]

Hey guys,

code below. Trying to convert a text field to date time and thought I would convert thwe text first using the below (from 20110131 to 01/31/2011 as an example), but I keep getting "must use Updateable query" Any help appreciated as its a long time since I programmed, but this loooks fine to me and the select brings back good formatted data.

UPDATE [detail report history]
SET [detail report history].REPORT_DATE =(Select mid ([detail report history].report_date ,5, 2)+'/'+right ([detail report history].report_date,2)+'/'+Left([detail report history].REPORT_DATE,4)FROM [detail report history]);

 

[PHV]

What about this ?

UPDATE [detail report history]
SET report_date = Mid(report_date,5,2) & '/' & Right(report_date,2) & '/' & Left(report_date,4)
WHERE report_date Like '########'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886