Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 08 Apr 2014 at 6:48am
that is how you are thinking about it.
If any record for the customer meets the date condition it means at least one of the groups also meets the condition which gets you the same result without convoluting the process.
If all of your groups needed to meet the condition then my suggestion is not valid.
Joined: 26 Nov 2012
Online Status: Offline
Posts: 15
Posted: 08 Apr 2014 at 11:01am
I See what you are saying but wouldn't that be evaluating the max date for all parts? the problem is that the max date can be 5 days ago but that max date is for one part only. another part can have a max date from last year. not sure if im being confusing.
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