Hi Zena,
You should use what is known as an Update query (one of the action queries that I
mentioned in my previous post).
1. Select the Queries object in the database window.
2. Click on the New button, and select Design View. Select the table of interest and
click the Add button. Then click on the Close button to dismiss the Select Table dialog
box.
3. Find the State column and double-click it to move it to the QBE (Query by Example)
grid. Alternatively, you can drag the field to the QBE grid, or you can click into the
Field cell in the QBE grid and select the field from the resulting dropdown.
4. At this point, you have created a simple SELECT query. You should see "Select Query"
indicated in the blue title bar. Since you stated that you want to put PA into every
cell, we don't need to apply any criteria to this query.
5. Still in query design view, click on Query > Update Query from the menu at the top.
You should see a new row in the QBE grid labeled "Update to:".
6. Enter PA into the cell with Update To: indicated.
7. Run the query by clicking on the maroon colored exclamation mark (or click on Query >
Run from the menu). If prompted "You are about to update 756 row(s), click Yes. Note:
Whether or not you receive a prompt depends on an option that is set under Tools >
Options, when viewing the database window. The default option is checked and is shown on
the tab labeled "Edit/Find", in the Confirm section, where the third choice reads "Action
queries".
That's all there is to it. You don't need to save the query unless you want to. These
directions might seem somewhat complicated, but they're really not. With practice, you
should be able to create a new update query like this and update all records with about 30
seconds worth of effort.
Tom
________________________________________
OK. Basic Question:
In one table I have a state column. I have 756 records. How do I put PA
into every cell without typing it in each of the 756 records?
