Update Null Values (1 Viewer)

[loki]

I have 78 records that have a field that is null. I want to create an update query to replace these null values with the value "NULL1" for the first record, "NULL2" for the second record and so on. I know how to replace the null values with the word null, but how do I get this last number to increment all the way to 78. Can anyone help?

 

[Pat Hartman]

If the field is numeric, this discussion is moot since you can't store a text value in a numeric field.

Null values have a purpose. If for some reason you don't want to allow nulls, you can change your table definition to make the field required and supply a default value (of course you'll need to get a value into the fields before Access will allow you to change the field to required).

If you can explain the problem you are having, someone will provide a solution.