Wretched Queries!!!!!!

[anthony.carter]

Hi,

In my database each entry has several scores assigned to it (for
different attributes). Each score is in the 1 -4 range.

I would like to construct a query that will select those entries that
have even so much as a single attribute that scores below a 4 and, if
possible, only return the attributes that fell below standard (4).

The database will have each employee (entry) assessed on a dozen or so
different attributes, each of which will be rated with a score of 1 -
4. I would like to be able to find out which employees had a score in
any attribute below 4 and which attributes those were, and only those
attributes (not bothering with the 'pass' mark of 4).

The solution evades me. Does the basis of this database need re-
jigging or is there a way round it?

All contributions gratefully received

Regards,

TC

 

[scubadiver]

My initial response would be that all like information should be in the same
table (ie. attributes should be treated as records rather than fields) then
you can filter all those attributes which have less than 4. I think creating
a query based on what you have could be difficult and time consuming. It
depends what trade off you want.

 

[John W. Vinson]

Does the basis of this database need re-
jigging

Yes. You're committing spreadsheet, storing data (questions) in fields and
storing a one to many relationship in each record.

or is there a way round it

Some fairly tricky VBA code, opening a recordset, looping through the
fields...

John W. Vinson [MVP]