add information quickly

[Pammy]

I have an access database with over 17,000 records. In one column I have
done a filter to filter out all "LPS" and then in another column filter
"Identification Made". With these 2 columns filtered, I see all the blank
columns and I want to add "ADM". Is there a quick way to do this without
having to copy ADM and then Paste down each row. I looked at find and
replace, but I cannot get it to find a blank and then fill in. I only want
this added where "LPS" is showing in one column and "Identification Made" is
showing in another.
Thanks,

 

[Tom Wickerath]

Hi Pammy,

Create a SELECT query with the criteria that you need. Add the field with
the blank values. Then convert the query to an UPDATE query. You should see a
new row in the QBE (Query By Example) grid that reads "Update To:". Enter ADM
in the Update To that corresponds with the correct field. Run the query.

Note: Before running any action query (Update, Append, Delete), it would be
a good idea to make a backup copy of your database (or, minimally, a backup
of the table that you will be updating). That way, if something goes wrong,
you can easily recover.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________