Just to finish.................... I need to work out the following:- (1) no. records in the subset where another field's value is >=0 (2) the sum of the contents of that field in those records
(3) no. records in the subset where the value of the same field above is < 0 (i.e. negative) (4) the sum of the contents of that field in those records I can code (1) and (3) but how to do (2) & (4) ? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144949.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
