Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    7

    Question Unanswered: exprssion builder problem

    I have a table and there are three items( AccountID, Deposit, Payment).
    I want to create a table and according to the different AccountID calculate the amount separately ( for example, AccountID 123, depositAmount:150, paymentAmont:100).

    I just want to try to use the expression builder to do it like this

    =Sum(Switch([AccountID]="123", [Deposit], [AccountID]="234",[Deposit]))

    but the result is the total of Deposit, not according to the different AccountID.

    Could anyone tell me what's wrong with it and How to use expression builder correctly?

    Any suggestion is welcomed.

    Thank you

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: exprssion builder problem

    Originally posted by harry_hurry
    I have a table and there are three items( AccountID, Deposit, Payment).
    I want to create a table and according to the different AccountID calculate the amount separately ( for example, AccountID 123, depositAmount:150, paymentAmont:100).

    I just want to try to use the expression builder to do it like this

    =Sum(Switch([AccountID]="123", [Deposit], [AccountID]="234",[Deposit]))

    but the result is the total of Deposit, not according to the different AccountID.

    Could anyone tell me what's wrong with it and How to use expression builder correctly?

    Any suggestion is welcomed.

    Thank you
    If you want the total of Deposit for each AccountID make a query from your table, don't use the Sum with Switch not work like you want.
    Saludos
    Norberto

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •