Aug 16, 2003 #1 Brian56 Programmer May 29, 2003 66 CA Must be a simple answer but I cant seem to see it. How do i add a number to a field of an existing record ?
Must be a simple answer but I cant seem to see it. How do i add a number to a field of an existing record ?
Aug 16, 2003 #2 sleipnir214 Programmer May 6, 2002 15,350 US Something like: UPDATE tablename SET columnname = columnname + 1 WHERE rowidentifier = somevalue Want the best answers? Ask the best questions: http://www.catb.org/~esr/faqs/smart-questions.htmlTANSTAAFL!! Upvote 0 Downvote
Something like: UPDATE tablename SET columnname = columnname + 1 WHERE rowidentifier = somevalue Want the best answers? Ask the best questions: http://www.catb.org/~esr/faqs/smart-questions.htmlTANSTAAFL!!