How to make more text fields in queries in Access 2007

  • Thread starter Thread starter Lilian
  • Start date Start date
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
 
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.
 
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.
 

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

Count text values in a Access Field 0
Problem with a query in Access 2007 1
To make a query from two independent tables 1
Defining Text field sizes in destination Make-Table Query 3
Make table query: [Enter 1] AS Test 1
Make Table Query-Access 2007 2
Query field size quandry 2
Can rich text format (memo) carry over in a make table query? 1

Back
Top