Hello Dyre Many thanks for your suggestions...............
The primary key consists of the first two columns being Date and Hours e.g. 01-01-2009, 0 01-01-2009, 6 01-01-2009, 12 01-01-2009, 18 02-01-2009, 0 etc. Does this lead to alternative suggestions? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/selecting-records-in-a-derby-database-tp134896p134901.html Sent from the Apache Derby Users mailing list archive at Nabble.com.