Good day
Please assist.
Firstly - I am supressing 'repeated key values' in a workbook and secondly displaying the 'results' for a certain characteristic on the 'top right'. The following is the result:
Cal. year / month 2009/10
Customer Suffix Preferred Stocking P Wip Number Number of WIP lines Lines filled (P)
30 LTS Result 36 32
10673 5 5
63573 8 8
64368 23 19
63 LTS Result 2 2
10376 1 1
64822 1 1
The user only want to see the Results for each customer suffix and preferred stocking point...as follows:
30 LTS Result 36 32
63 LTS Result 2 2
This is the only way I could structure the query to get to the required results
Seems as if the only way to hide the rows beneath the results if with VB code. Can someone assist me with that please?
thanks
Cj