At 2/2/00 , you 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!
>
an update query will do the trick:
query, new, design view
select table with the field you wish to update and click add button
click close button
drag field you wish to update from the table listing to the query grid
click on Query on the main menu
choose Update query
in the query grid you should now see a row called "Update to"
in that space under your field enter a Yes or -1
then click on the ! on the menu bar
close query (save if you wish....)
you are done
A French Norman in a foreign land,
pining for the fjords whilst waiting for the
Hippotami to find solace , it's a game I play with the solitary feeling.
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|