of the questions that you asked I don't really know how to
answer it, but here it goes. The Datatype that I'm trying
to build consists of multiple agents, their scores from
monitors, their managers name, department, and the team
their under. Each section of the monitors is also broken
down into fiels consisting of yes,no,ni,and na. The
yes,no,ni, and na has a value of 1 or 0, so in turn we can
get a raw score for each agent and also percentages. I
also want to create a master form where we are able to
print and view these stats whether we want individual
agents scores and averages for their monitors or an
overall score of the team, and also the center's scores
and averages. Currently, we have everything set up but I
but I don't know how to do the reporting end of it. I
don't know how to tell Access to run these specific
reports. I'm not sure if I have sufficient data.
Everytime I run a report it just shows one agent and one
call only. As far as your question regarding Null value I
do apologize for my ignorance in that matter. I have
never built a database before so I don't have the answer
to that question.
I really don't know how to help you at this time.
You have given me lot's of information about your "Database", but my
question was about the "Datatype" of the fields you were trying to add
up. A field's Datatype determines whether the value stored in the
field is treated as Text, or a Number, or a Yes/No field, etc.
For instance, you write that a field consists of "yes,no,ni,and na"
and that these field have a value of 1 or 0. That may very well be,
but if the field is really a Yes/No datatype (a check box), then the
value is -1 or 0, not 1 or 0.
So that may be why you are getting negative numbers. If that is the
reason, simply wrap the Sum expression in the Abs() function:
=Abs([Sum([FieldName]))
The above will change -5 to 5.
I would strongly suggest that you get a good book on Access and spend
some time learning the basics before attempting to create a database.
Time spent now with the basics will pay off for you in the long run.
Good Luck.
Oh yes, regarding Nulls.
A Null field is a field that contain no data. It is empty.
In Access, trying to add a Null field with a field that contains a
value, let's say = Sum(5 + 3 + Null) results in a Null, not 8. So
while there is a function to deal with this, you must be aware of what
Null is and how to work with it. Time to get that book!