Overflow !

[ras81]

good day,

i have a problem and i don't know what to do with it, so plz help i am breaking down here....

here is the query

SELECT Sum(QuantityFree) AS SumמתוךQuantityFree
FROM ( SELECT ItemsInOrder.itemName, Item.itemPrice, (ItemsInOrder.price-ItemsInOrder.DiscountGiven) AS PriceBeforeDiscount, PriceBeforeDiscount/Item.itemPrice AS QuantityOnPay, (ItemsInOrder.quantity-QuantityOnPay) AS QuantityFree, Item.itemID
FROM reports, Item INNER JOIN (ItemsInOrder INNER JOIN [Order] ON ItemsInOrder.orderID = Order.OrderID) ON Item.itemName = ItemsInOrder.itemName
WHERE (((Order.time)>[reports]![lastSummeryReport])));

the inner query works fine, when i want to SUM it, i get OVERFLOW.

what can i do?

thanks

 

[DCrake]

Simple Software Solutions

Overflow usually indicates that the value being returned needs to be a long integer instead of an integer. look at the properties.

For more help press Ctrl+G then type in Overflow hightlight the word and press F1

CodeMaster: