Having somer issues creating the sample database for the correct display on this site, please forgive me. I have attached a .doc to illustrate my issue. I hope this will...

Will read through the instructions and post back with the samples, stand by.

Unfortunately, your suggestion didn’t produce the desired results, the Check/Cash payment line is still on a row by itself, along with the date associated with it. Is there another way...

Hi Lowell,

Thanks for the quick reply, I will try as you suggested and get back with you. I am a little unclear as to your first suggestion - what...

Sorry guys, hit the submit button too quickly, here's the whole issue:

Hello all,

I'm running a query against 2 invocie tables and need the results or rows to line up.I know...

Thanks Mayank,

That worked on my test view, going to run a backup and run it against my working view. While I run the backup could you explain a little more...