M
mwhaley73
I am relatively new to dcounts. I have a table with one field containing
values a,b,c,d,e,f. In the query I have 3 calculated fields
(Staging,Success,Variance) which is a combination of record counts (i.e. a+c,
a-d-e-c+b,etc).
I used the dcount for each (a-f) and when I return the query, it ignores the
group by sourcesys set up in a previous field.
Here is an example of the return
businessDate SourceSys Staging
Count Exclusions Exceptions Errors Created Success Variance
7/23/2007 Amnet 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
7/23/2007 Beta 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
7/23/2007 CalypsoBO 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
7/23/2007 CalypsoCredit 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
Notice that the total of ALL records appears in every Sourcesys. any idea
how to execute this
values a,b,c,d,e,f. In the query I have 3 calculated fields
(Staging,Success,Variance) which is a combination of record counts (i.e. a+c,
a-d-e-c+b,etc).
I used the dcount for each (a-f) and when I return the query, it ignores the
group by sourcesys set up in a previous field.
Here is an example of the return
businessDate SourceSys Staging
Count Exclusions Exceptions Errors Created Success Variance
7/23/2007 Amnet 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
7/23/2007 Beta 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
7/23/2007 CalypsoBO 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
7/23/2007 CalypsoCredit 239,537.00 -28,379.00 -8,000.00 -11,630.00 1 191,529.00 0.00
Notice that the total of ALL records appears in every Sourcesys. any idea
how to execute this