Stock Quantity With Decimals

[Former Member]

Hi All,

I have noted that we've got some stock items whose Quantity include Decimals yet they are suppossed to be whole numbers.

For instance: for Bread: OITM.OnHand=10.5

I want to come up with a query to display all these kind of items. Whats the right Condition in an SQL query to achieve this? Thanks

Regards,

Henry

[Former Member · Accepted solution]

Try this query:

Select itemcode, itemname from OITM where Onhand > Round(Onhand,0)

Thanks,

Gordon