shanegair (9/27/2016)
I only want to value the inventory of LBS on the items with the 'C' for the UOM COntrol. Thanks
I'm not sure whether you think that you've provided sufficient information for a person with no knowledge of your data whatsoever to solve your problem, but your requirement so far
I only want to value the inventory of LBS on the items with the 'C' for the UOM COntrol
Leads to a
SELECT col1, col2
WHERE [UOM Control] = 'C' and UOM = 'LBS'
solution.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.