The ANDs were jacking my query up. Commas used instead makes it work just as it should.
UPDATE tleasepayments SET LeasePaymentDollars=21337.0000 , CropSharePercent='0' , Notes='PUT SOME NOTES HERE' WHERE LeaseID='1214' grr, COMMAS!!!!! You win this time... -- View this message in context: http://n4.nabble.com/Problem-Updating-mySQL-Record-tp1475274p1475880.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution