Leeds Knight
New Member
- Joined
- Jun 17, 2010
- Messages
- 2
I have two named Tables detailing price proposals from mfrs on different dates
I want to merge these into a single table detailing the minimum cost and associated detail per Item
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Requirement - single table by Item number, telling me who has provided the lowest quote with which MPN value:
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
I want to merge these into a single table detailing the minimum cost and associated detail per Item
Item | Mfr | MPN | Cost |
10001 | Acme | ACME001 | 1 |
10002 | Bob's | BOB001 | 1.5 |
10003 | Tom's | TOM001 | 2 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Item | Mfr | MPN | Cost |
10001 | Bob's | BOB002 | 1.5 |
10003 | Tom's | TOM001 | 0.5 |
10004 | Bill's | BILL001 | 4 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Requirement - single table by Item number, telling me who has provided the lowest quote with which MPN value:
Item | Mfr | MPN | Min Cost |
10001 | Acme | ACME001 | 1 |
10002 | Bob's | BOB001 | 1.5 |
10003 | Tom's | TOM001 | 0.5 |
10004 | Bill's | BILL001 | 4 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>