Can't 'Find' #N/A - "The search item was not found"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WDSnews - 09 May 2008 22:23 GMT

In Access 2007, I've imported over 3000 rows from an Excel spreadsheet.
There are a few fields containing "#N/A" (without the quotes), which I wish
to find and manually correct. However the Find and Replace tool fails to
find them. I can search and Find "N/A", but that doesn't allow me to
replace all four characters of "#N/A". So I want to search and Find "#N/A".

As usual, the new Help system fails to help. Isn't it amazing the new help
system is able to offer 100 documents to view, and not one of them is
appropriate to the question of "Find symbol", or "Find #"? (Earlier this
week, I searched Word help for "Outlining Keyboard Shortcuts". Phewey!)

Thanks for your help.

Reply to this Message

WDSnews - 09 May 2008 22:39 GMT

AHA! I found it 2/3rds down a long Help article titled "Access wildcard
character reference". The solution is to search for "[#]N/A". You can see
that article listed if you search for "Find symbol", skip the first 25
articles and look halfway down the list of the second 25 articles.

> In Access 2007, I've imported over 3000 rows from an Excel spreadsheet.
> There are a few fields containing "#N/A" (without the quotes), which I
[quoted text clipped - 9 lines]
>
> Thanks for your help.

Reply to this Message

Rastro - 09 May 2008 22:57 GMT

You could make a Find&Replace with a sql sentence like this one:
----------
UPDATE Table SET Table.Field = Null WHERE Table.Field = "#N/A";
----------

Replace the objects (table, field) with their names and Null with the
replacement value. If you want to clear the field you need to leave it as it
is (field=null)

Hope it helps

"WDSnews" <wdsnews.0640@oregoncity.com> escribió en el mensaje de
noticias:uyts3rhsIHA.4912@TK2MSFTNGP03.phx.gbl...

Reply to this Message