Kim Wiggins
kimjwiggins at yahoo.com
Fri Aug 5 08:09:31 CDT 2005
Well yes, I do have a field called quantity(i) because I have fields that correspond to parts that are 1-8. Thanks, I didn't see that space. Stuart McLachlan <stuart at lexacorp.com.pg> wrote: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com