How do i change a null field to a value in an acess query?

[Guest]

I am running a query in Acess that produces a null field for a few of the
results (this is intentional.) How do I run another query to change the null
field to a value of 91. I have the formula as this:
Quality: IIf(([Percent])=Null,91,([Percent]))

Am I missing something simple?

 

[Guest]

You can use the NZ function, that will replace Null with 91

Nz([Percent],91)

 

[Keith Leslein]

Hello There there are different ways to do this:

You can use the NZ function in your original query. You can place this
function in the Queryfield itself:

Test:Nz([FieldName],The Value you wish to store if the field is null)
If it is always going to be the same value you can use this method.

or to create the update query:

Include the query you wish to update, in the field you wish to update
(QBE Grid) in the Criteria list place is null, and in the Update To row
place the value you wish to update it to.

Thanks!