Dear All
Any help will be appreciated. I have made a query:
SELECT T1.[ItemCode] AS 'Item No.', T1.[ItemName] AS 'Item Description', T1.[OnHand] AS 'In Stock', T1.[InvntryUom] AS 'Stock UoM', T0.[UgpName] AS 'UoM Group Name' FROM [dbo].[OUGP] T0 INNER JOIN [dbo].[OITM] T1 ON T1.[UgpEntry] = T0.[UgpEntry]
Can someone amend this for me, so I may be able to:-
1. User should be asked to enter the range of the Item code
2. Inactive products should not show up.
Thanks in advance.