I have a table with 89577 records and 36 columns. It is a table displaying measurements taken from many different sheep (all with an individual ID). The columns represent different traits for which measurements were taken eg fleece weight, body weight etc. My problem is not all traits were recorded for all animals leaving a whole lot of spaces throughout the table. To analyse this info the spaces need to be "NA" so the program can recognise the trait was not recorded. Is there an easy way to do this? Find and replace would be good however it doesn't recognise "blank" as a value it can find to replace it with NA. I am using Access 97.