Missing Query column

  • Thread starter Thread starter ronnie_knight
  • Start date Start date
R

ronnie_knight

I have a query and while in design view, I unchecked the show button on
a column. Now I realize I need to see that column, but when I go into
design view, it is not there to re-check the show button. How do I get
it back?
 
First of all, make sure it's really not there. If you have a criteria on
the field and uncheck it, Access will move it to the far right. If you've
checked that and it's still missing, just open the field list (there's a
button on the toolbar) and drag the missing field back onto the query grid.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Ronnie,

In design view of your query, locate the field in question, in the
applicable table represented in the upper panel of the design window,
and drag it to a blank column in the query design grid.
 
You must log in or register to reply here.

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

Similar Threads

Acees Queries Hidden Column 1
Field dissapears from query when "Show" is unchecked 3
Access stripping decimal places in query 1
Make table query only runs from design view. 3
Sizing queries 3
Open up a query in design view 3
Can't Unhide Table Columns 2
Unhide query design grid in design view. 3

Back
Top