Count Yes/No for three fields in one column

  • Thread starter Thread starter Marilyn Myers
  • Start date Start date
M

Marilyn Myers

I work with Access 2007. I have a table with 4 columns: Date Mailed, 2nd, C
w/o Inv, and C w/Inv. I can get the monthly totals by grouping on Date
Mailed and each individual column. Is there a way to combine the totals for
2nd, C w/o Inv and C w/Inv that are Yes/No boxes into One column? I use the
following for each individual column:
YesCount1st: Abs(Sum([1st]))

How do I write the expression to include all three fields in one column?
Thanks in advance for any help someone can give.
Marilyn
 
Marilyn -

I think you want this:

= Sum(Abs([2nd]) + Abs([C w/o Inv]) + Abs([C w/Inv]))

--
Daryl S


KARL DEWEY said:
YesCountAll: Abs(Sum([2nd] + [C w/o Inv] + [C w/Inv]))

--
Build a little, test a little.


Marilyn Myers said:
I work with Access 2007. I have a table with 4 columns: Date Mailed, 2nd, C
w/o Inv, and C w/Inv. I can get the monthly totals by grouping on Date
Mailed and each individual column. Is there a way to combine the totals for
2nd, C w/o Inv and C w/Inv that are Yes/No boxes into One column? I use the
following for each individual column:
YesCount1st: Abs(Sum([1st]))

How do I write the expression to include all three fields in one column?
Thanks in advance for any help someone can give.
Marilyn
Click to expand...
Click to expand...
 
Back
Top