This is a tough one to ask... I am trying to find a 'simple' way to do the following:
I have a set of data (qty, owner, description) I am getting the data by going through databases and getting bits and pieces of information to create this big list of data.. Where I was heading was to create a query (QueryNew) and giving each of these bits of data their own column. All well and good .. but the end result is to Group all the owners and SUM all their quantities .. but this self built Query won't allow me to do this... Does anyone have any recommendations on how I would slam all this data from different places, group it together so I can see the TOTAL quantity of Each OWNER/DESCRIPTION value? (Owner and description go hand in hand). Thanks in advance. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
