How to make more text fields in queries in Access 2007

L

Lilian

Hello Access experts!
I have a question is it possible to make more text fields in a query? I have
a query that needs to take out a lot of info from connected tables. The numbe
of text fields that I see in query design is 17. Is it limited or there is a
possibility somehow to make more?
Best regards,
Lilian
 
B

Brendan Reynolds

Lilian said:
Hello Access experts!
I have a question is it possible to make more text fields in a query? I
have
a query that needs to take out a lot of info from connected tables. The
numbe
of text fields that I see in query design is 17. Is it limited or there is
a
possibility somehow to make more?
Best regards,
Lilian
Click to expand...


Click 'Insert Columns' on the 'Query Setup' group of the 'Design' tab.
 
J

Jerry Whittle

You should be able to add many more. Scroll all the way to the right past the
last field. Then drag and drop a field from a table there. It should create a
new column.
 
Top