If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count Yes/No for three fields in one column
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 |
#2
|
|||
|
|||
Count Yes/No for three fields in one column
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 |
#3
|
|||
|
|||
Count Yes/No for three fields in one column
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 |
Thread Tools | |
Display Modes | |
|
|