Thank's John........................... I now realise that when I create a new record I enter 0.00 into the profit/loss field
I guess I should leave that field out when writing a new record and then try your suggested code to update that 'blank' field Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-the-last-column-in-the-newest-record-tp143710p143715.html Sent from the Apache Derby Users mailing list archive at Nabble.com.