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!