Re: retrieving records based on a single column contents

Thanks John I wasn't sure how to enter NULL into an integer field and so col3 has many zeroes as well as 1, 2, 3, 4, etc. and so (a) do your suggestions change at all ? (b) how do you enter NULL into an integer field ? (c) how do you set up col3 to be indexed ? Thank you Bob M -- View

Re: retrieving records based on a single column contents

On 01/05/2015 04:50, Bob M wrote: Hi I have a single database table where the primary key is (col1 =Date, col2=Time) say This works fine when I wish to delete the oldest record for instance However I have another column say col3 which holds an increasing sequencial number (i.e. 1, 2,3 etc but