Identify records on change of field 1

[TimothyP]

Hello,

I am using Crystal Reports 2013.

I have a SQL table with about 50K records that looks like this.

I want to identify the accounts that have an Inventory_Flag of 'Y' AND 'N'.

In other words, using the sample data above, the only Account I want to identify is 78989.

Thanks for any assistance you can provide.

TimothyP

 

[lbass]

Group on Account Number and then go to report->selection formula->GROUP and enter:

Distinctcount({table.inventory_flag},{table.acctno})>1

-LB

 

[TimothyP]

Exactly what I needed. Thank you LB!