How can I Query all fields

[Box666]

I have a database, one table of which has approx 50 fields to it.

We now need to query each field in the table, I have tried to use the
"query grid" but you can only query about 9 fields. (as you appreciate
you have to drop a line in the grid to query the next field - thus you
can only query 9 fields at a time.)

How can I achieve this please.

In case it is important, I want to run this query from a form, where
the operator can just type in part of a reference code and then have
the answer viewed in a report on screen.

With thanks.

Bob

 

[Douglas J. Steele]

Just because the grid defaults to 9 rows of criteria doesn't mean it's
limited to that. You can insert extra rows under the Insert menu.

 

[Box666]

Just because the grid defaults to 9 rows of criteria doesn't mean it's
limited to that. You can insert extra rows under the Insert menu.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)











- Show quoted text -

So simple - thank you

 

[gls858]

I have a database, one table of which has approx 50 fields to it.

We now need to query each field in the table, I have tried to use the
"query grid" but you can only query about 9 fields. (as you appreciate
you have to drop a line in the grid to query the next field - thus you
can only query 9 fields at a time.)

How can I achieve this please.

In case it is important, I want to run this query from a form, where
the operator can just type in part of a reference code and then have
the answer viewed in a report on screen.

With thanks.

Bob

Something just doesn't sound right here. Set criteria for 50 fields in
one query? Am I understanding that correctly? I find it hard to believe
this would be necessary. Probably indicates a design flaw in the
database. I could be wrong but this just sounds rather strange.

gls858

 

[Douglas J. Steele]

Something just doesn't sound right here. Set criteria for 50 fields in
one query? Am I understanding that correctly? I find it hard to believe
this would be necessary. Probably indicates a design flaw in the database.
I could be wrong but this just sounds rather strange.

Heck, having 50 fields in a single table sounds wrong to me, but I was just
answering the question, not passing judgement! <g>