Summing 2 Fields together

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

Guest

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
 
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
 
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...
 
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...
 
Back
Top