Change an update query

J

JLUTHER

I have an update query I need to make changes to but when I open the design
view it onlt shows the field that is updating. Can anyone tell me how view
the other fields?
 
J

John Spencer

Are you in query design view (with the grid)? If so, you should see the table
that you are updating and be able to see the fields. If you are basing the
update query on another query, check the base query to see if it has the other
fields in it.

If the upper portion of the query is missing (tables area) then you need to
drag down the section of selecting fields and setting criteria. If that does
not work for you, then
switch to SQL view,
copy the text,
open a new query (don't add any tables),
switch to SQL view,
paste the text,
switch back to design view and
save the new query (with the same name as the old if you want)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top