What's the problem of this special kind of FORM ??

[Martin]

(I don't know the English to express this kind of special FORM)


I draw the [Amount] into the data area, I expect the data to be:

¡¡¡¡¡¡¡¡ ¡¡year
month
Amount
Dealer1 3010 (USD)
Dealer2 1882



But, to my surprise, the result is as below:

¡¡¡¡¡¡¡¡ ¡¡year
month
Amount:Count
Dealer1 5 ( 5 counts, that's 5 business got amount 3010 USD )
Dealer2 2


Question:
What's wrong ! I want to get the computer automatically show the amount, but
not the count. How to ?

Thanks!

Martin

 

[Guest]

You might have count instead of Sum

If the ControlSource of the Diller text box say
=Count([FieldName])

Change it to
=Sum([FieldName])