Displaying reports with only certain records

A

awach

I have a report that lists one customer per pg and then has a subreport that
lists all the products they've ordered. I want to put a text box product
description/statement in the main report only if the customer has purchased
that type of product.

For example, for the customer below, I want to display the text box for the
products in the aa, bb, and re categories, but display a textbox for the nn
and sd categories.

Please help!!!

Customer 1

Bought: name product number
prdt 1 aa12
prdt 2 aa57
prdt 3 bb87
prdt 4 re79

Hasn't bought:
prdt5 nn74
prdt6 sd61
 
D

Duane Hookom

I am having trouble understanding posting since we don't know where the
product description come from. Also your final sentence seems like there
should be a "not" in there someplace since there is the work "but".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top