Query fields or expressions limitation?

In the Design View for a Query in Access 2007.
I have a query using 13 fields and 2 expressions.  I want to add a 3rd expression but there are no more places.  Is there a limitation?
Thanks,
Brooks
query.jpg
gbnortonAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
select any column in the query grid and click on Insert Columns from the ribbon
0
 
gbnortonAuthor Commented:
Too easy.  Thanks.  Is there a way to add to the end?
0
 
Rey Obrero (Capricorn1)Commented:
just shift (highlight and drag) the last populated column to the blank column to the left. Select the blank column and click on InsertColumns again to add more columns.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.