Some referrals do not have end dates and there may be multiple referral numbers per client. Without any filtering applied each referral number is displayed on distinct lines.

 

I wish to filter the results with the following criteria - exclude all clients and referrals when all referral end dates occur before 01/04/09. In other words some clients may have referrals that ended prior to 01/04/09 but these referral entries need to be displayed because there are other unended or were ended after 01/04/09 for the client.

 

I hope this makes sense and any advice would be gratefully received.

 

It includes all referrals for client no = 30959 because they had a referral end date after 01/04/09. It has excluded client no = 12487 because all referrals ended prior to 01/04/09.