Sql Query In Access .. Division By Zero Error
Kindly note i am using Access97
i want to run a create table query , The problem is Field50 has records with zeros in it also the result of Field34+Field35+Field37+Field33+Field36 too gives out zeros hence i am getting Division by zero error ..
pls suggest some alternative to solve this error so i can run this query
SELECT NRBOMBS.shipper, , Sum(NRBOMBS.Field51) AS REV1, Sum(NRBOMBS.Field50\[NRBOMBS].[Field34]+[NRBOMBS].[Field35]+[NRBOMBS].[Field37]+(NRBOMBS.Field33+NRBOMBS.Field36)) AS revenueperbox INTO custwise
FROM NRBOMBS
GROUP BY NRBOMBS.shipper
ORDER BY Sum(NRBOMBS.Field51) DESC;
Thanks very much for all your help extended
SQL PROBLEM .. DIVISION BY ZERO ERRO
URGENTLY PLS HELP ME ... WITH THIS REGARDS ENABLE ME TO RUN A CREATE TABLE QUERY ..
THANKS FOR ALL HELP EXTENDED