Can anyone tell me how/if I could using query400 take a list of records, subtotal and create a file with only the subtotals for export to excel? My file is all orders, with line items and $$ for each line. I need to subtotal the orders by order # and create a file listing only the customer #, order# and the order total for export to excel. Is there a way/how I can create a result field to hold the subtotal amount? I can sum the line item $$ but it puts it in its own row and breaks. My fields/columns are (A)Cust# (all the same customer #), (B)Order#, (C)part#, (D) line $$. Orders have a variety of line items. I have just over 5000 records. I want one file with (A)Customer#, (B)Order#, (C)Order total. Any tips or hints how I can accomplish this? Can it be done with query? Thanks, I appreciate any help.
March 12, 2009 3:48 PM
March 12, 2009 4:54 PM