how to do complete multiple replaces throughout table in ms-access
- by silverkid
i am a little confused in finding out what would be the best way to replace all occurances of
1. Blanks
2. -
3. NA
from all collumns of TableA with question mark ? charachter.
Sample Row in orignal tableA
444586 RAUR <blank> 8 570 NA - 13 - SCHS299 MP 339 70 EN <blank>
Same Row in Expected TableA
444586 RAUR ? 8 570 ? ? 13 ? SCHS299 MP 339 70 EN ?
please help me out
I cant use the Find Replace Toolbar of access.