Kyalo (1/7/2013)
Thank you Folks, yes I am brand new in this forum. From the two questions, it appears as if I have already included the suggested test data (the two examples).let us assume there is table named Contracts with the following attributes
Contracts Number (varchar10)
startdate (datetime)
enddate (datetime)
contractAmount (currency).
In my previous post I have already identified what I would like the output to be formatted as.
Hope this helps
Actually, you didn't. What you provided requires that we take the time to create your table(s), create the insert statements to populate the table(s) with your data. We are all volunteers on this site helping others on our own time. The more you can do for us, the better answers you will get.
Please read the article I reference below in my signature block regarding asking for help. It will show you what you should post and how to do it when posting questions in the future.