Hi,


I have a problem that will probably be simple to solve but I just can't see it. I have an Access table mostly populated but one field partly populated but includes Null values. I cannot simply use an Insert Into query as the Null value has to be different on every occasion with up to 130 consecutive additions of 16 in the column. Also the Query then has to reset for the next record null. There are 137 records to be updated with varying lengths. This affects some 12,000 odd individual records to be updated. Can someone suggest how to structure this query.
I have attached a spreadsheet with a sample of the data in the table with the offending field highlighted..
Thanks in advance.