OK....NO Errors!!

But as you probably assessed, no results either....

So where am i going wrong???

I mean that I was able to show the results prior to this...and so that you may understand the output data that I am trying to show...

The first column of data should be string, the 2nd and 3rd is integer...the last column which is why I created this thread is the currency field....

Also the data for the last 2 columns are set up in the SQL server as integer and money respectively....

So the output should have 1st column string followed by the integer then currency...I am assuming that the problem lies in the output to the table???

You have helped me greatly so far, maybe you have a moment to see if I can get this to work with what I have???

Thank you.