Expression Builder

[Hai Le]

I'm currently writing an Access database for a call center
for the QC department inorder for us to keep track of
calls and monitors score. However, when I get to the
expression builder inorder to formulate an expression to
tell the database to add up certain fields, it always adds
it up in negative numbers. Please let me know what I'm
doing wrong. I think I might be inputing the expression
the wrong way. Please let me know the correct expression
to add up these fields. Also, if you have any suggestions
or ideas on how to build a database for a call center I
would greatly appreciate some advice. Thank you!

 

[fredg]

I'm currently writing an Access database for a call center
for the QC department inorder for us to keep track of
calls and monitors score. However, when I get to the
expression builder inorder to formulate an expression to
tell the database to add up certain fields, it always adds
it up in negative numbers. Please let me know what I'm
doing wrong. I think I might be inputing the expression
the wrong way. Please let me know the correct expression
to add up these fields. Also, if you have any suggestions
or ideas on how to build a database for a call center I
would greatly appreciate some advice. Thank you!

What Datatype are the fields you are adding?
What is the exact expression you are trying to use?
What is the actual result you are getting?
What should the result be?
Can some of the fields being added have a Null value?

 

[Hai]

-----Original Message-----


What Datatype are the fields you are adding?
What is the exact expression you are trying to use?
What is the actual result you are getting?
What should the result be?
Can some of the fields being added have a Null value?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Well, this is my first time building a data base so some

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.

 

[fredg]

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!