Thanks for the info

But I think I have explained this wrong...

I need clients that their last record on the recorded_Service table is today - 80

if anyone has any examples that would be great

Thanks

Joe