Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Martin, Nov 8, 2005.

  1. Martin

    Martin
    Expand Collapse
    Guest

    (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
     
  2. Loading...

    Similar Threads Forum Date
    What's The Exact Meaning Of Sangat.... Questions and Answers Feb 14, 2015
    USA What's the United States Up To in Asia? Breaking News Nov 19, 2011
    What's his name? (Dhadrianwale?) Questions and Answers Jul 31, 2011
    What's the right thing to do? General Jun 12, 2011
    SciTech What's in Store for Technology in 2011? Breaking News Dec 19, 2010

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    You might have count instead of Sum

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

    Change it to
    =Sum([FieldName])

    "Martin" wrote:

    > (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
    >
    >
    >
     

Share This Page