Using cr2008 v12 with vs2008 and an access db. This select statement works in Access but cr2008 says failed to retrieve data from db Error Code 0x80040e10. Those that are named fld[].
SELECT AccountNumber, AmountPaid, (trim(Lastname) & ', ' & trim(Firstname)) AS Name,
(trim(StreetNumber) & ' ' & trim(address)) AS sAddress,
(trim(City) & ', ' & trim(State) & ' ' & trim(zip)) AS CityStZip,
Format(Telephone , '(000) 000-0000') AS Phone,
(fldMonth & '/' & fldDay & '/' & fldYear) AS DatePaid
FROM Customers
ORDER BY Lastname, Firstname
Tried the Access code in CR2008 stand alone and in VS2008. Same results. Also tried inserting only one of the fields - fldYear in CR2008. Same result.
Any ideas would be great. Thank you.
IP Logged
