[AccessD] SQL statement

Stuart McLachlan stuart at lexacorp.com.pg
Thu Aug 4 21:46:04 CDT 2005


On 4 Aug 2005 at 19:29, Kim Wiggins wrote:

> My application is telling me something is wrong with this sql statement for my Access database.
> Can anyone figure out what's wrong?  I don't see anything.
> strSQL1 = "update tblRepairPartsReplaced set quantity (i) =  '" & Val(txtQty(i)) & "'  Where part_no = '" & txtPartsRep(i).Text & "'"
> Thanks
> Kim
> 


There is a space between quantity and (i). Having said that, do you really 
have a field called "quantity(i)" ?

I'd guess you just want     ...quantity = '" & .....




-- 
Stuart





More information about the AccessD mailing list