null is query's 2003 access

[dreamdelerium]

one more thing. in the query design window, for an update query, you can enter criterias. what if your criteria is an empty (or null) value. i tried just using Is Null but it doesnt replace the old values. (ie, if value = "N/A" or null value, change to 99)

 

[mattkorguk]

Criteria should read something like this: "N/A" or Is Null or " "
You'll probably find that the values aren't actually Null, just blank.

 

[dreamdelerium]

yeah, ive tried that. it doesnt seem to work

 

[mattkorguk]

What results do you get if change it to a select query and have the criteria as Is Null?
Just try each value on it's own, and check results. You've probably tried that too though?!

 

[LPurvis]

Can you post the actual query you're currently using? (From SQL view of course

 

[Brianwarnock]

In the updateto code
=IIf(Isnull([fieldname]) OR [fieldname] =" " OR [fieldname]="N/A",99,[Fieldname])

Brian