We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Query fields or expressions limitation?

gbnorton
gbnorton asked
on
Medium Priority
218 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Too easy.  Thanks.  Is there a way to add to the end?
CERTIFIED EXPERT
Top Expert 2016

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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.