Thank you for your quick response!

I tried your suggestion, but I was not successfull...I believe that it has to do with my columns and the aggregate function.

Here is the code...

That is EXACTLY what I was looking for...

I ran it through my SQL Query Analyzer...and it cambe back with an error:

Server: Msg 170, Level 15, State 1, Line 1

Line 1:...

Thank you all very much...for your assistance!

Everything is working fine.

This is a great forum, and I am learning alot from the active dialog in here...keep it up!

I do not understand what you mean....

Could you explain a little more...I am a newbie at most of this!

Thank you.

The datatypes for the fields in question are as follows:

System - Fields - Datatype

Access - ServiceLevel - Number

...

What I mean by proper is accurate....

I think that I may have confused some...I am sure that someone has come across this problem (if it is a problem)...

Basically, the numbers...

Ok...in the Access query I have the following as an expression:

xServiceLevel: IIf(Sum([handled])=0,0,Sum([servicelevel]*[handled])/Sum([handled]))

In SQL I have the following so as to mimic the above:

(CASE Sum(handled) WHEN 0 THEN 0 ELSE 100*Sum(servicelevel*handled)/Sum(handled)...

Osoba,

Thank you very much...your hack code worked great...

Would you mind passing me some info on the substring, and why you came to this conclusion...it will definitely assist me in understanding...

That makes perfect sense, yet I probably should have stated that this SQL statement is within a JSP page, and is connected to the SQL Server by way of...