How to pull records out that are different

[CuteGeek]

Hello,

I have a report that I need to only select the below records. How do I do this when there is nothing in the database that make them distinct.

Group 1 14987

Acount Number Company

14987 100
14987 300
14987 200
14987 100


Group 1 23444

Acount Number Company

23444 100
23444 100
23444 100


I need only to see the Group 14987 on this report because they have different companies for the same account number.

I tried to do a group by but got stuck with how to pull those records out.


Thank you,
Cute Geek

 

[Durango122]

hi
if you have access to ms query design a view and
used the distinct select

Durango122

 

[lbass]

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

distinctcount({table.company},{table.accountnumber}) > 1

-LB

 

[CuteGeek]

Thanks you guys

I was taking the long way around trying to write a stored procedure I figured it out yesterday evening.

Have a good one...and thanks again