0 Replies Latest reply: Feb 11, 2013 9:23 AM by Sandeep Hamelink RSS

    order by expression - deadline this thursday

    Sandeep Hamelink

      Dear QV-users,

       

      I have a big problem,

       

       

      I would like to transform this SQL qeury to a QV-expression to use wihitn a table or bar-chart

       

      SELECT

           count(NUMMER_

      FROM

      A

      WHERE

      SUCCES = 1 AND

      START =  SCHOOLSTART AND

      DATE_EXIT < TODATE

       

      ORDER BY

      KWALIFICATION, COST, SIZE_EDUCATION, CONNECTION NUMBER,

       

      I am able to create this formula, but it is essential for me to embed the order by statement within an expression to use in a table or bar chart.

      I am yet NOT abel to do the part of order by.

       

      any help on this short notice would me tremendously appriciated.

       

      Gr. Sandeep