0 Replies Latest reply: Sep 22, 2013 3:23 AM by Leon Shlimak RSS

    Table with different values on same field

      Hi guys!

       

      I have the following fields:

      Account ID

      Query ID

      Data Value

       

      I want to create a table which will have the following columns:

      Account ID,   Data Value (where Query ID=1), Data Value (where Query ID=2), Data Value (where Query ID=3)....

       

      Any idea how this can be done by using a calculated field?

       

      Thanks for your help!