Thanks, I will try this. CSDunn

quote:

---

Two choices as I see it. First is to wrap all of your query, except the OScore...

It turns out that I had a mismatch in the constraint I was testing vs. the one I was altering. I'm having to develop this application and answer calls on...

The other option I was considering was just to create a calculated field in the MS Access Project (ADP) report that uses this particular query by implementing 'IIF' statements in...

I tried 'AVG(CAST(TS.TestScore AS Decimal(4,2))) AS Average_Score' and was still getting the 'Arithmetic Overflow' error, so I tried a couple of tests:

1. I made a copy of the table from...

Thanks for your help. cd.

Well, the log clearly says that the eval period has expired. I didn't expect the cause of the problem to be so easy to find. Thanks. cd.

The inability to make a connection to that instance of SQL Server is preventing me from looking in the 'Management' section of that instance.

I wound up putting my error checking code in the application interface. In this case it was an Access 2000 Project.

I found out that SQL Server 2000 passes its errors...

Actually, I had a unique index and a unique constraint set up on the same fields. I dropped the constraint, then added a new unique nonclustered index with Ignore_Dup_Key, and...

quote:

---

I agree. I usually trap such errors in my app before calling upd or if using a stored proc then I trap...