We ship many gifts from our comany, using the "Gift Order-One or More Address". Some of our customers send something to themself, some send as many as 25 gifts out. We mail catalogs and each catalog is marked with a Source Key. I can easily run a report based on the Source Key that tells me how many "orders" we entered for each Source Key. What I want to know though is how many ACTUAL ORDERS (includes gifts and non-gifts) were placed based on the Source Key...i.e., how many gifts and non-gifts were sent based on the Source Key.
Currently, when I run the report it would tell me that 1 order was placed using Source Key "XXXX". Let's say that that one order actually had 6 gift recipients on it. I want my report to tell me that there 6 orders using that Source Key and not just 1.
Any help with this would be greatly appreciated. Report thru MOM, Report thru Report Writer? Help Please!
Thanks!
Katy
KatyCR
Member Since 15 Jan 2007Offline Last Active Apr 09 2007 10:41 AM