*RESOLVED* Rounding to 2 Decimals Within Access 97??

[Salvatore]

I am creating Java Server Pages that connect ( at present) to an Access 97 database...

I need to know if anyone out there knows the proper function for rounding a double integer to 2 decimal places, thus removing the floating numbers...

I am having a heck of a time figuring this out, and that is why I have come to you!!

I need to change the following sql Select statement to round specific fields:

"select ID, RepName, PhoneTotal, EmailTotal, MailTotal, AUX, ACW, TalkTime from qryCPMS  " _
& "where [tblHBUS.Unit Manager] = '" & unitMgr & "' and [tblProductivity.Unit Manager] = '" & unitMgr & "'  " _
& "and tblHBUS.Month = '" & month & "' and tblProductivity.Month = '" & month & "' and tblHBUS.Year = '"& year &"' " _
& "and tblProductivity.Year = '" & year & "' ORDER BY ID ")

Any assistance will be extremely welcomed!