RE: TO USE SQL or something entirely different.

2001-05-02 Thread Windle, Kevan
Sounds to me like you need to differentiate between orders and packages. If you had a table: Order_package,shipper(UPS or US Mail),weight,destination,date With all the separate orders marked as order. Then use a sum query to total all packages going to same destination on same date. Either add

RE: TO USE SQL or something entirely different.

2001-02-27 Thread Elizabeth Marcotte - Selphcotte Web Designs
Jeff If I understand you correctly - you could create arrays - loop through the arrays comparing whatever fields you are using to determine the same records going to the same place, do the calcs on those records - update another array with the totals for each "same place" - this new array will

Re: TO USE SQL or something entirely different.

2001-02-27 Thread Jeff W
ECTED] Sent: Tuesday, February 27, 2001 12:21 PM Subject: RE: TO USE SQL or something entirely different. Jeff If I understand you correctly - you could create arrays - loop through the arrays comparing whatever fields you are using to determine the same records going to the same place, d