I would not mind having a breakdown of incorrect answers by question , as you stated in the last reply...

You stated that this would involve the questions table with the...

I am a bit ignorant here...but what is the table def that you need??

Are you referring to the column names and some sample data?

Sorry..

Thank you very much...it is working!

the total count is inaccurate???

The query below is giving a wrong number based on a comparison from the SQL Server table...

select count([inquiry_type]) AS [Count], ([inquiry_type]) AS [Inquiry Type] FROM tblOAO...

How do I accomplish your suggestion?

Would you explain your code??

This is what I have currently:

select count([inquiry_type]) AS [Count], ([inquiry_type]) AS [Inquiry Type] FROM tblOAO Where oao_date2 BETWEEN '"+dayA+"' AND '"+dayB+"' GROUP BY [inquiry_type]

dayA and dayB...

Mike,

Were you able to see my PM...I am very interested in what you think I need to do to make my SELECT statement work???

Thank you.

How do you send a pm?

I went to the button, but I did not see an option to send a private message...

Mike,

It did not work...could you look at my select statment and see where I am wrong?

select datepart(mm, Col001) as theMonth, substring(convert(varchar,cast(SUM(Col003) as money),1),1,charindex('.',convert(varchar,cast(SUM(Col003) as money),1))-1), substring(convert(varchar,cast(SUM(Col004) as money),1),1,charindex('.',convert(varchar,cast(SUM(Col004) as money),1))-1),...

I believe this is what I am looking for...

You see..I have a JSP that is pulling data from a table on my SQL Server...as it stands I have the JSP...

DSP,

Thank you for your response...I looked at the site...and I am more lost...it talks about writing a Visual basic script that will be executed by DTS..

I am not familiar with...

I began creating a txt file that has the steps for the http://ftp...but that is where I got lost...

I would like to use the suggestions from either Mike...

Thank you all for your valuable responses.

I have it working now...thanks to all of you.

Maybe I need to clarify a little...

I have a column in my SQL Server tbale that I need to count records that have specific criteria, I also need to sum...

I apologize...I do not understand what you wrote????

Is this supposed to work in the SQL Server?