Subject Re: Totaling fields in a report From Mervyn Bick <invalid@invalid.invalid> Date Thu, 22 Dec 2022 15:56:55 +0200 Newsgroups dbase.getting-started On 2022/12/22 15:05, charlie wrote: > Thanks...   Got this error > > Database Engine Error:  Type mismatch in expression. > > sure enough qty is text and price is numeric. > > Would I use cast to fix this? > > sql = "select i.*,cast(qty as numeric(10,2))*price as cost from imp_spd.dbf i ORDER BY MFG,SKU" Mervyn.