home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,304 of 9,834   
   Hotmail.com to All   
   Paradox 5 (Win)   
   20 Mar 07 14:54:39   
   
   Hi,   
      
   Is there anyone who can help me making a simple SUM   
      
   DB1   
   ----   
   BarCode   
   Count   
      
   DB2   
   ----   
   BarCode   
   Text   
   Price   
   ...   
      
      
   I want to get all the records (including dubblets) in DB1 and then get   
   the Count to summerize a total count. Then I want to calc the total   
   Count with Price (without dubblets).   
      
   When I try some records are calculated correctly others not.   
      
   Query Test1   
   DB1   
   -----   
   Barcode V   
   Count calc sum all as Total numer   
      
   DB2   
   -----   
   Barcode   
   Text V   
   Price V   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca