Find and Replace

[PhilT via AccessMonster.com]

I am not sure I post this in the right place. Anyway, I like to perform Find
and Replace in Access Table. Sometime, I imported data with blank into table,
and Access treats this empty field as Null, not Zero. How can I perform Find
and Replace these Null data field with something else such as Search Null and
Replace with SystemName.

 

[Steve]

If you are usong Access XP or later, look at the Replace function in Help.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John W. Vinson]

I am not sure I post this in the right place. Anyway, I like to perform Find
and Replace in Access Table. Sometime, I imported data with blank into table,
and Access treats this empty field as Null, not Zero. How can I perform Find
and Replace these Null data field with something else such as Search Null and
Replace with SystemName.

I'd simply use an Update Query (rather than search and replace). Use a
criterion of

IS NULL

on the field.


John W. Vinson [MVP]