Find and replace #N/A

[Teuntja123]

Hi all,

I've imported a table with 1500 cells with #N/A value,
Adjusting the bron data is not possible, so I have to change the values in Access. (it must be changed into a "Y")
When I filter the column on #N/A and use the Find an Replace function with the following rules:
Find What: #N/A; Replace With: Y
It says the item was not found.

Can someone help me?

 

[namliam]

Try using an update query?

MVG vanuit Amsterdam

 

[Teuntja123]

I can use an update query, but what is to fill in by criteria? #N/A doesn't work..
It would be easier if I know what to fill in the Find What section so it will find/replace #N/A..

 

[pr2-eugin]

If you simply use a SELECT Query with the Criteria as #N/A do you get any result?

SELECT * FROM yourTableName
WHERE theField = "#N/A";

 

[Teuntja123]

I already tried
Find what: "#N/A", #N/A, "N/A", N/A, NA(),

 

[pr2-eugin]

You are not listening.. Forget about Find and Replace functionality. Try the SELECT Query or UPDATE query.

 

[Teuntja123]

Thanks, solved it with the update query! Made a mistake in my previous one.

 

[pr2-eugin]

Okay if you say so ! Good Luck !