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 that to the same table with order_package set to package or to a separate table listing packages. -----Original Message----- From: Jeff W [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 16:29 To: CF-Talk Subject: TO USE SQL or something entirely different. I need a good starting point. I am looking to streamline our shipping procedures. Right now I generate two queries that divide out packages that are going UPS and US mail. Thats the easy part.. These insert easily into our standard UPS software. LOL What I would like to do. Each business card order is shipped pretty much separately (for drop ship purposes and the fact that not every color is produced everyday). So A UPS query may have multiple sets of cards (records) going to the same place. How in the world can I take that query, combine all the records that are the same, add their weights up and insert them back into the list only once??? I am open for suggestions. Jeff Priority Business Cards ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
