Hi!
Hope someone can help me out, I'll really appreciate it.
I have an access table containing 3 fields with bill of material data.
The content of just one product looks like this:
field_Product, field_Component, field_Qty
FP-5026-19-CHO, UP-5026-19-CHO, 1
UP-5026-19-CHO, WS-5026-19 , 1
WS-5026-19 , RM1 , 23
WS-5026-19 , RM2 , 11
WS-5026-19 , RM3 , 1.5
UP-5026-19-CHO, FF-5026-19 , 1
FF-5026-19 , RM4 , 23
FF-5026-19 , RM5 , 0.456
UP-5026-19-CHO, ST-5026-19 , 1
ST-5026-19 , RM6 , 23
ST-5026-19 , CT-5026-19-CHO, 1
CT-5026-19-CHO, RM7 , 14
CT-5026-19-CHO, RM8 , 14
I need to output a list looking like this, without the subassembly parts.
FP-5026-19-CHO, RM1 , 23
FP-5026-19-CHO, RM2 , 11
FP-5026-19-CHO, RM3 , 1.5
FP-5026-19-CHO, RM4 , 23
FP-5026-19-CHO, RM5 , 0.456
FP-5026-19-CHO, RM6 , 23
FP-5026-19-CHO, RM7 , 14
FP-5026-19-CHO, RM8 , 14
The table contains similar data for many more products.
I have been trying nested queries but have not been able to get the result I need.
Any ideas?
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar