Joined: 25 Oct 2011
Online Status: Offline
Posts: 1
Topic: Record selection problem :( Posted: 25 Oct 2011 at 5:53pm
Hi all - I'm relatively new to Crystal Reports, but I'm having the greatest difficulty with selecting a specific set of records. I've tried everything and looked everywhere, but I can't get it to work!
I have a database that looks like this:
mbr_number month closure_date
101 5
101 6
101 7 15/9/2011
102 5
102 6
102 7 15/10/2011
What I want to do is select the 3 records with member number 101, because one of the closure_date fields for that member falls within September 2011. So if ANY of the closure_date records fall in September I need to select ALL member numbers associated with that record.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
