From: nospam@nospam.com   
      
   Geez this thing LOL!  posted before I was ready.   
      
      
   Hope some knowledgeable soul can tell me how to do this.  I have a table   
   with 3 cols: an ID number and 2 quantities.  I can sum up each of the   
   quantities   
   easily by checking the ID column and putting "calc sum" in the other 2 cols.   
    But I also need to add a 3rd column which is the sum total of the other   
   2 calc sum columns.   
      
   In SQL it looks something like this:   
      
   select ID_num, sum(q1), sum(q2), (sum(q1) + sum(q2)) as total_sum   
   from table1   
   group by ID_num   
      
      
   but how do I do this with a QBE?  It's imperative that i do this with QBE   
   because this will be contained in a script with a whole bunch of other QBEs   
   and they use tilde variables to work together systematically, and I haven't   
   had any luck using tilde variables in in SQL queries in .ssl scripts.   
      
   I tried this - it provided an answer but it was the wrong one.   
      
   ID_num | q1           | q2                                      |   
   check  | _1, calc sum | _2, calc sum, calc _1 + _2 as total_sum |   
      
      
   Any other suggestions?  Thanks!   
   -Rick M.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)