Find and Replace

  • Thread starter PhilT via AccessMonster.com
  • Start date
P

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.
 
S

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
[email protected]
 
J

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.
Click to expand...

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]
 
Top