|
Hi Everybody, I'm getting a headache trying to figure this out. It may just be the way DP works, but this is what I need to do. The company I do business with has come up with three catalogs for three separate product groups --- call them catalogs "A," "B," and "C." My customer database has a parent record (name, address) and a child record (mailing list categories) containing one or more various categories which correspond to the product groups. I want to create seven different lists of the following groups. A B C AB AC BC A, B, and C. I've done reports for years extracting names based on specific categories with subreports using Stop-Skip, but I can't figure how to do this. First I tried listing all the "A" categories (using "contains") grouping them with parenthesis, then the "Bs," then the "Cs" and using "or" between the groups within one RV. I then tested to see if the RV was true, but it's always false. (Yes, there customers that fit the model. I then tried moving the categories to three separate RVs, and then testing that RV with "and" statements to see if all three were true. Still no results. I haven't even tried to work out the formula for "A and B, but not C," etc. If I couldn't get the one for A, B, and C, I figured, what's the use! Could someone please guide me as to an approach that would work? Thanks! Charlie Wolf |
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
