Hi All, I need to make query fro

[damien110281]

Hi All,

I need to make query from a table which has about 21 fields, and i want to include all 21 fields applying a query criteria to just one field to sort a mountain of information.
The problem is a query is only 16 fields wide. How do I get around this problem?

Thanx for any help,

Damien

 

[JoeMiller]

Go into the query's design view and select the remaining fields that aren't appearing. Then you'll have all the fields, next apply the criteria to the field you are sorting on and you should be all set.

Joe Miller
joe.miller@flotech.net

 

[Tim1]

Hi Damien,

Why don't you try selecting the * for column1 of your query. For column 2, pick the column that you want to sort on, and then uncheck the "show" box. You can still put your criteria into this field, and Access will use it for the sorting, but it will not print the column twice in the results.

Tim

 

[damien110281]

The thing is i want to make this query into a form and so want to include all 21 fields in the query.

 

[JoeMiller]

Queries are not limited to 16 fields wide, Access just doesn't display cells past so many to the right. All you have to do is include the additional fields, drag them down to your grid and Access will make room for them.

Joe Miller
joe.miller@flotech.net

 

[damien110281]

Thanx Joe.
I was going about it the wrong way all along.I was starting in Design View rather than using the wizard hense the confusion.

Damien