>Dear All,
>I have a table with mainly numerical fields, how I can scan or search all fields for a certain number for example
>in different field I have the number lets say 6 and whenever I found this number I want to replace it with 4.
>if there is a way to do it and hope I explain it properly
>thank's a lot for your help
>Best for now

Are you sure you didn't mean records?
I can't imagine what information you keep in all numeric fields that allows you replace 6 with 4 in ALL fields?