Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

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
0
gbnorton
Asked:
gbnorton
  • 2
1 Solution
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now