Filter from multiple fields using the same filter criterion

[Tammy]

Hi,

I have a user who would like to know if she can filter multiple fields,
using the same filter criterion for each field, but she doesn't want to set
the criteria for each field because there are over 100 fields. I haven't seen
the database yet, but can only assume it's not set up very well, if she is
looking for the same criteria in multiple fields within the same table.

I haven't found a way to filter directly through Access without setting the
criterion for each field. Does anyone know a way? Is there a way to do it
through VBA, maybe?

We are using Access 2007 / Vista OS.

Thanks for any suggestions!

 

[Steve Schapel]

Tammy,

... but can only assume it's not set up very well, if she is
looking for the same criteria in multiple fields within the same table.

Your assumption is correct.

Please first of all ask your user if she can consider a review of her
table structure.

 

[Tammy]

Hi Steve,

Thanks for your response. My user's database tracks responses to questions.
Therefore, she has the same data in different fields, because the numbering
of her "answers" to questions are the same. So, in this case, it makes sense
for her to be tracking the same type of information in different fields.

If she wants to see all the answer "9" for each field, she'd like to know if
there is a way to filter out all the "9's" from each field, without inputting
the criterion for each field.

Any suggestions?? Thanks!

 

[Pieter Wijnen]

Still bad design.
the questions should be in a separate table (Questions) with one question
per row.

Pieter

 

[Tammy]

Hi Steve,

Any suggetions for this one? Or, maybe a start point where I can do some
research on my own?

Thanks, again!

 

[Steve Schapel]

Tammy,

Your statement "she has the same data in different fields, because the
numbering of her answers to questions are the same. So, in this case, it
makes sense for her to be tracking the same type of information in
different fields" ... is incorrect. I support Pieter's reply as well.

Therefore, my earlier reply still holds... Please first of all ask your
user if she can consider a review of her table structure.

 

[Tammy]

Hi Steve,

Thanks, again. I'll talk to her. What did you mean that you supported
Pieter's reply, also? I don't see where anyone else, except you, responded to
my question.
Thanks.

 

[Steve Schapel]

Tammy,

Pieter Wijnen posted a reply, to your earlier reply, in which he said:
"Still bad design.
the questions should be in a separate table (Questions) with one question
per row."

I don't know why you do not see it.

 

[Tammy]

Thanks, Steve - nope, his reply does not show in the thread. Thanks for
repeating it for me. It's a great suggestion, too.

Well, thanks for taking the time to reply to my posts. Have a great day!