Criteria for Report Generation pulling incorrectly

  • Thread starter Thread starter sugarbean97
  • Start date Start date
S

sugarbean97

I have two reports I create, one for merchants who have a Debit balance in
their account, another for merchants who have a Zero balance in their
account. The balances are grouped by merchant, using the amounts from a
table. Today, I received a zero balance account on the Debit report, and the
same merchant was excluded from the Zero balance report. I verified the
entries in the table did not have an additional decimal position (hence,
rounded incorrectly). Any other suggestions as to why this merchant was
placed on the incorrect report?
 
sugarbean97 said:
I have two reports I create, one for merchants who have a Debit balance in
their account, another for merchants who have a Zero balance in their
account. The balances are grouped by merchant, using the amounts from a
table. Today, I received a zero balance account on the Debit report, and the
same merchant was excluded from the Zero balance report. I verified the
entries in the table did not have an additional decimal position (hence,
rounded incorrectly). Any other suggestions as to why this merchant was
placed on the incorrect report?
Click to expand...

I suspect that the balance really is a (very?) small anount.
These can be difficult to detect so try adding a calculated
test field to the query with an expression like:
Test: balance * 100000

OTOH, maybe the field has a value of Null. If so, try using
the Nz function.
 
Back
Top