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