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
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
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
3 matches
Mail list logo