Prev: How to find text that is surrounded by a wild card, specificly
Next: Final Reminder - Microsoft Responds to the Evolution of Community
From: Marilyn Myers on 28 May 2010 12:34
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
From: KARL DEWEY on 28 May 2010 13:03
YesCountAll: Abs(Sum([2nd] + [C w/o Inv] + [C w/Inv]))

--
Build a little, test a little.


"Marilyn Myers" wrote:

> 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
From: Daryl S on 28 May 2010 13:46
Marilyn -

I think you want this:

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

--
Daryl S


"KARL DEWEY" wrote:

> YesCountAll: Abs(Sum([2nd] + [C w/o Inv] + [C w/Inv]))
>
> --
> Build a little, test a little.
>
>
> "Marilyn Myers" wrote:
>
> > 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
 | 
Pages: 1
Prev: How to find text that is surrounded by a wild card, specificly
Next: Final Reminder - Microsoft Responds to the Evolution of Community