Query Reporting

[Patti_G_(Guest)]

I am trying to set up an argument to run a report that will show all customers who have NOT purchased a particular item, or list of items, but may have HAVE purchased an item that could be used with item #1. For Example__Customer A has not purchased any Disposable products but they HAVE purchased the hard good that uses the particula Disposable. ____I also want to show in the same report, ALL customers who have not purchased the same disposables ____

[kfleming]

You can do this using two preprocessed totals that are sums of logical fields.____The first logical field would be true if a product is a disposable.__For example if there is a prodtype field in your table that has a D for disposable your calculated field expresson would be:__PRODTYPE="D"____The second calculated field would test for your second hard good codes__You then create two total fields. Each one sums the calculated field and resets by customer. Use the Total Processing tab to make these totals pre-processed.____Then in your query you would include all records where TOTAL1 is equal to 0 and TOTAL2 is greater than 0 to see all customers who did not buy a disposable but did buy a hard goods item.____Hope this helps. ____Kathleen__R&R Support