overflow error?

[joe]

I have a sales query that duplicates an earlier sales
query run against an older version of an imported sales
file.

When I attempt to run the updated query with the updated
table, I get an overflow error. But the earlier copy of
the same query doesn't generate the error when I run it
against the older table. What generates these errors?

Thanks in advance for your help.

The SQL of the query that generates the error follows:

SELECT [Inventryasc 2-28-2003].SubDescr AS [APA Item No],
[Inventryasc 2-28-2003].Descr AS Title, Sum([2003
Convention Sales].[Qty Shipped]) AS [SumOfQty Shipped],
[2003 Convention Sales]![ListPrice]/[2003 Convention
Sales]![Qty Shipped] AS [Unit Price], [2003 Convention
Sales].ItemID
FROM [2003 Convention Sales] LEFT JOIN [Inventryasc 2-28-
2003] ON [2003 Convention Sales].ItemID = [Inventryasc 2-
28-2003].ItemID
GROUP BY [Inventryasc 2-28-2003].SubDescr, [Inventryasc 2-
28-2003].Descr, [2003 Convention Sales]![ListPrice]/[2003
Convention Sales]![Qty Shipped], [2003 Convention
Sales].ItemID
ORDER BY [Inventryasc 2-28-2003].SubDescr;

 

[John Spencer (MVP)]

Well, if QtyShipped is ever zero then you can get an overflow error since you
are dividing by zero. That is the first thing I would check.

If that doesn't solve it, try removing one column at a time from a COPY of the
query until it works. At that point you will at least have a good idea of which
column is causing the problem.