Summing 2 Fields together

K

KRB

I know this is probably easy, but I am having a hard time getting my 2 fields
to sum up. I have field MON and field MONLAST that I want to sum together. My
current formula is =Sum(Abs([mon]=1 And [monlast]=1)), but it's not given me
any returns. I also have tried =sum(abs([mon] +[monlast])). Any help would
be greatly appreciated.

Thanks,
KRB
 
J

Jeff Boyce

The expression you gave appears to be trying to "count", not "sum". Which
are you trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KRB

I want to add the 2 fields together. Mon+Monlast. I'm wanting a total count
of my Monday absence, which I have already determined my Monday's, just need
to combine these 2 fields together to get the total count.

Jeff Boyce said:
The expression you gave appears to be trying to "count", not "sum". Which
are you trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

KRB said:
I know this is probably easy, but I am having a hard time getting my 2
fields
to sum up. I have field MON and field MONLAST that I want to sum together.
My
current formula is =Sum(Abs([mon]=1 And [monlast]=1)), but it's not given
me
any returns. I also have tried =sum(abs([mon] +[monlast])). Any help
would
be greatly appreciated.

Thanks,
KRB
Click to expand...
Click to expand...
 
J

Jeff Boyce

If what you want is [Mon] + [MonLast], use that. You don't need to use
Sum().

Regards

Jeff Boyce
Microsoft Office/Access MVP


KRB said:
I want to add the 2 fields together. Mon+Monlast. I'm wanting a total
count
of my Monday absence, which I have already determined my Monday's, just
need
to combine these 2 fields together to get the total count.

Jeff Boyce said:
The expression you gave appears to be trying to "count", not "sum".
Which
are you trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

KRB said:
I know this is probably easy, but I am having a hard time getting my 2
fields
to sum up. I have field MON and field MONLAST that I want to sum
together.
My
current formula is =Sum(Abs([mon]=1 And [monlast]=1)), but it's not
given
me
any returns. I also have tried =sum(abs([mon] +[monlast])). Any help
would
be greatly appreciated.

Thanks,
KRB
Click to expand...
Click to expand...
Click to expand...
 
Top