Suppress if NOT duplicated formula

[mjm19]

In the Format Editor there is a field where you can simply check off to suppress duplicated data. In the case I have on this report I want to do the reverse. All the data is there, I just want the duplicates. This report runs off a query like so:

{Query.TestCode} in ["MRCM", "DIFIS"] and
{Query.Result} in ["ABNL", "AUTOA", "NORMAL", "NSA"]

I get a list of 100's of Accession numbers (this is a Hospital ... each # refers to a patients result) that have either one or both of these tests with one of the results listed. If it's there on both, I get 2 separate entries for that accession number. That's the data I want to pick up.

Any help would be appreciated. Thanks

 

[SQLBill]

What program are you using? It doesn't appear to be for Microsoft SQL Server, which is what this forum is about.


-SQLBill