JeannetteC
Programmer
Hi,
I would like to create a report that is based in order lines. It will prompt for two products or sets of products and a time period.
I want to establish which customers have bought productA and not productB, productC and productD.
I have tried using master detail; creating a filtered detail query and using customer=customer and product<>product. But I am not quite getting the reult I want - instead, it shows me those customers that bought productA and shows everything except productB,C and D if they did buy them.
Does that make sense?
I'd really appreciate any help as we would like to upsell to past customers to offer special discounts based on the product they alreafy bought.
Thanks
Jeannette
I would like to create a report that is based in order lines. It will prompt for two products or sets of products and a time period.
I want to establish which customers have bought productA and not productB, productC and productD.
I have tried using master detail; creating a filtered detail query and using customer=customer and product<>product. But I am not quite getting the reult I want - instead, it shows me those customers that bought productA and shows everything except productB,C and D if they did buy them.
Does that make sense?
I'd really appreciate any help as we would like to upsell to past customers to offer special discounts based on the product they alreafy bought.
Thanks
Jeannette