This is exactly how I have the entire query.

SELECT item_location_view.item_id AS 'Item',

item_location_view.item_desc AS 'Description',

inv_mast.class_id1 AS 'Brand',

item_location_view.location_id AS 'Location',

item_location_view.qty_on_hand AS 'Qty on Hand',

item_location_view.qty_allocated AS 'Qty Allocated',

item_location_view.qty_on_po AS...

I normally used to refer to numbers. is not correct?

Hi linn,

thank you all for your help.

This is the situation in qty_on_hand does not appear the quantity that are in 0. What I need is to show all quantitys on...

Hi,

I want to output to be online. I normally run it on an excel spreadsheet.

Thanks

First Thanks for your reply.

I have a query and I want someone else in another country to be able to see that query so I want to put it online.

Thanks