Select on comparison of detail records?

[sugabutt]

I need to be able to do a selection based on a comparison of the salesman number that re in 2 separate records, where the saleman number doesn't match.

Currently I have the data grouped by customer number. And I'm selecting on Type (1 and 7). If the salesman number for these two records do not match, then I need to see it listed on the report.

Cust# Type Salesman
1234 1 2222
1234 7 2222
--- would not need these records above selected, because the salesman number matches

Cust# Type Salesman
5555 1 1111
5555 7 2222
--- I would want to select these 2 records because the salesman doesn't match.

Any suggestions on how I can do this?

 

[lbass]

Go to report->selection formula->GROUP and enter:

distinctcount({table.salesman},{table.customer#}) > 1

-LB