Thank you.. Really appreciate the help...

Hi,

Sorry rookie mistake, I edited the post to show the table info, hopefully that helps..Thanks

Thank you really appreciate the response. it work great, and I see where I was over thinking the WHERE Clause..

Thanks for responding, what I am trying to do is sum up payments for individual person, I need to sum FYTD;
Example:: ( July 1st 2017 to July 30...

Thanks for the quick response, as a SQL beginner Scott first respond look fine to me, I don't quite understand the other suggestion
if possible a quick example might allow...

Thank you all for your reply's, and comments, as a rookie I am learning a lot from the exchanges between you experts, especially the do's and don't when creating Dynamic...

Steve,
Thank you very much for your reply, it work great... Really appreciate it...
,

Thank you all for your response... I really appreciate you expertise.