I have data such as:
PO Num Qty
12345 10
12346 20
12345-1 5
12346-1 5
123 7
123-1 3
I want to create a summary count for the base left digits before the -x
PO Num Qty
12345 15
12346 25
123 10
I have tried many combos of queries and they all come out with a data type mismatch:
Any idea of how to do this....?
PO Num Qty
12345 10
12346 20
12345-1 5
12346-1 5
123 7
123-1 3
I want to create a summary count for the base left digits before the -x
PO Num Qty
12345 15
12346 25
123 10
I have tried many combos of queries and they all come out with a data type mismatch:
Any idea of how to do this....?