Keith Gladstone wrote:
> Does anyone know a way to change the contents of one field in every record within Access 97?
> What I need to do is change a 0 to -1 in a field formatted as yes/no, it will save me having to change every record in a file that has 1550 records!
>
> K Gladstone
>
>
> Curious about the people moderating your
> messages? Visit our staff web site:
> http://nospin.com/pc/staff.html
Keith, in the table view of the table, highlight the column that you wish to change. Then click on the Edit option in the toolbar. You can then select
the Replace option to display the data you want to find and it's replacement (enter your choices). Now you may select find to locate the first to
replace, then click on replace, if all works as you want then you may click the replace all.
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|