Here are step-by-step instructions for creating the query you need. I
have written the query in such a way that you canjust paste it in,
rather than trying to describe in words where on the screen you have
to click to build it yourself. Once you have pasted it in, you can
look at it in Design View to see what you do to build one of these
yourself using the Query Designer.
Please ask for clarification if you have any questions.
Note: Since an update query changes data, and you are new at this, it
is a good idea to make a backup of your database before running your
1. Choose Queries from the Objects Bar on the left hand side of the
2. Double-click Create query in Design View.
3. A box will appear offering you a list of tables. Click Close.
4. There is a View dropdown button on the Toolbar all the way to the
left under the File Menu. If it does not already say SQL, choose SQL
from the dropdown. Click the button.
5. A Query window will appear. Paste the following Query into it.
UPDATE pixman SET pixman.Image01 = "1" WHERE [SubjectType]=[Group];
Note: In my sample, all three fields are text. If Image01 is a number
in your database, remove the double quotes around the 1.
6. You can now select Design View from the View dropdown button to see
how this query looks from the regular design view.
7. Click the Save button on the Toolbar to save the query and give it a name.
8. Close the Query designer. You should now see your new query in the
Database Window. To run it, double-click on it.
For reference, I have created a small mdb with a table with the three
fields you mention, a query called Update Image01 that runs your
query, and a query called Clear Image01 that resets the Image01 field
to blank. You can download it from
http://www.hammerdata.com/Google/update_query.mdb . It was built in
Access 2002, so it may give you a version warning when you open it in
2003. Go ahead and let it upgrade if it wants to.
Again, please ask for clarification if you have any questions.