anyone can give a suggestion?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm trying to create a scorecard database. There are 5 different areas
measured each week, hence 5 different scorecards. I'm trying to include
conditional formatting so that when one area drops below a certain mark, that
field will be red.

Now, i originally was using the Avg of each criteria, but that turned out to
be a flawed design because i could not for the life of me figure out how to
make it all neat and tidy. in the end, i had 2 queries (for each scorecard,
which means i had FIVE replicas!) which are basic replicas of each other,
except that one was used for forms, and the other solely existed for me to
tie it to a Master Cond Frmt query (i tried using the first one for the
Master Cond Frmt Query, but it just ended up with an error message " circular
reference")

The problem is, we are adding more and more measures, and the form is now
taking AGES to load up....Therefore, i just dropped the whole idea of
comparing it to the average....So now, i need an idea of how to compute a new
target number (each number will be different for each plant, and i currently
have 20 plants...so i can't really come up with a number from thin air...)

Help?? or perhaps you can help me come up with a neater way of comparing it
to the average...either way,...HELP!!!!
 
If you would use a crosstabs query you could average all the scores and have
that average in the query to use to do the conditional formatting in a form
or report.
 
Ok, i'm trying to do this, and i'm failing miserably!!!

Say, i have Plant Name, OrdMissing, OrdSuspended...how do i get it to look
like:

Plant Name OrdMissing OrdSuspended
A _____ _________
B _____ _________
etc....

And the other thing is, it said that there can only be one value ....i have
almost 30 criteria for which i need the Avg for....
 
Do you want to average all of the OrdMissing, etc. or all the scores for
Plant A, etc.?
Ok, i'm trying to do this, and i'm failing miserably!!!

Say, i have Plant Name, OrdMissing, OrdSuspended...how do i get it to look
like:

Plant Name OrdMissing OrdSuspended
A _____ _________
B _____ _________
etc....

And the other thing is, it said that there can only be one value ....i have
almost 30 criteria for which i need the Avg for....
If you would use a crosstabs query you could average all the scores and have
that average in the query to use to do the conditional formatting in a form
Click to expand...
[quoted text clipped - 22 lines]
Click to expand...
 
Back
Top