Hi Dave:
> Do you get the error when you just do the select?
Yes.
t1.hhn t2.eid t2.sid t2.dserv t2.servcod t2.numclie
---------- ---------- ---------- ---------- ---------- ----------
98231 123 151 07/06/2001 6500 1
98231 123 151 07/07/2001 9933 1
992984 122 114 07/05/2001 9933 1
992984 122 114 07/05/2001 6500 1
994103 62 120 07/05/2001 6500 1
-ERROR- Division by zero. (2553)
> Is ZERO set ON or OFF?
ZERO is set OFF
> What are the datatypes of the columns unit and numclient?
Unit Type : NUMERIC ( 5, 2) NOT NULL
Comment: Units of service
NumClient Type : INTEGER NOT NULL
Comment: Number of clients present
