Skip to Content
0
Former Member
Jul 31, 2008 at 12:02 AM

Returning data if it meets certain criteria

26 Views

I'm new to CR XI and looking for some help in returning data

I have a single table that includes variouse transaction data:

User ID

Transaction type

Season

Price type

I want to be able to return the User ID and variouse transaction data only if field season = mc07-08

Example:

If User ID 7 also has a transaction and the seaon field = mc06-07 then I don't want to see the data

I'm trying to identify customer who only had a transaction where season = mc07-08

If the customer had transactions in other years they I don't want results being displayed.

Thanks

Shaun