fill a field in a filter

[Guest]

If I have a field in a table that I do a filter on so I have 100
records...and I want to change the value in the field.........is there any
way I can edit one record and then cut and paste to fill it all the way down
through the 100 or do I have to do them all individually? The find feature
did not work for me. Is there a fill down commnad or something?

 

[Guest]

Hi JRS,

You should be able to use an update query to update your records. It is
always a good idea to backup your database [or at least the affected
table(s)] before running any type of action query. Here is a tutorial that
should be helpful:

Change existing data by using an update query
http://office.microsoft.com/en-us/access/HP051880881033.aspx


Also, with so much duplicate data in the same table, you might want to
consider creating a lookup table. In Access 2000/2002/2003, click on Tools >
Analyze > Table. Read the first screen of the Table Analyzer wizard for a
description of the problems that can result from having repeated data stored
in records. A lookup table will allow you to easily provide a combo box on a
form, so that a user can select the proper value, instead of having to type
it in each time.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________