Query Design Grid Columns - id like some more plz :-)

W

WebDude

Um... LOL.. in one of my queries, i sorta.. well.. i ran out of columns
in the design grid.

Im using MS ACCESS 2000.. is there an option in the menu that will
show me more columns or add more to the grid?

I count 16 columns on my design grid. Which ive all used up with
Calculated fields, fields with criteria and fields for display.

Jeff.
 
J

Jeff Boyce

Jeff

With the query open in design mode, highlight one of the columns in the
lower grid. Click on menu item "Insert", and "Column".

Regards

Jeff Boyce
<Access MVP>
 

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

Design Grid Missing?! 1
Access Query - Query Help Is Greatly Appreciated!!!! 5
Using the "OR" cells in query grid 0
Questionnaire Query 11
My query works, but won't open in design view - any ideas? 7
Automatically "fit" query design view table/field grid columns. 2
Crosstab Query: Column Headings! 2
I'm stuck on developing a system to "flag" when 2 criteria are met 2

Top