Change an update query

  • Thread starter Thread starter JLUTHER
  • Start date Start date
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?
 
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
 
Back
Top