G
Gary F Shelton
SKU June08 NET LBS/CS July08 NET LBS/CS AUG08 NET LBS/CS
15010664 #error 24
#error
MCL03622 #error #error
#error
BCI00255 17 17
17
GFR40 #error #error
19
MCL03622 24 24
#error
80010094 #error 32
32
Need help with getting at a sku level the net LBS/CS. What I have is 12
months of data and in some months there is a value and in some there are not.
The good thing is that the vlaues are always the same but what I don't have
is one complete column that has the value. I think this is some sort of IIF
sttement but don't know how to write this multi dimensional statement... All
I want is one final column (query) that has one column of sku's and one
column of NET LBS/CS.
15010664 #error 24
#error
MCL03622 #error #error
#error
BCI00255 17 17
17
GFR40 #error #error
19
MCL03622 24 24
#error
80010094 #error 32
32
Need help with getting at a sku level the net LBS/CS. What I have is 12
months of data and in some months there is a value and in some there are not.
The good thing is that the vlaues are always the same but what I don't have
is one complete column that has the value. I think this is some sort of IIF
sttement but don't know how to write this multi dimensional statement... All
I want is one final column (query) that has one column of sku's and one
column of NET LBS/CS.