Hi All, I am kind of stuck on finalize a crucial report in MS Access..... and tried to Google it as well but didn’t find any useful solution....
I will try to explain it with an example...
Lets Say i have a Table in Access with below data:
Table 1:
<tbody>
</tbody>
and its linked with below table of deliveries... with Field "Material"
<tbody>
</tbody>
Now while creating a query on both tables with Ordered qty and Delivered Qty, results are displayed as below...
<tbody>
</tbody>
i want to avoid repetition in Order Qty column in final output as it gives a wrong image of order qty to be double or multiples of No. of Deliveries.
I will try to explain it with an example...
Lets Say i have a Table in Access with below data:
Table 1:
Material | Description | Qty |
A | AXYZ | 5 |
B | BXYZ | 10 |
<tbody>
</tbody>
and its linked with below table of deliveries... with Field "Material"
Delivery | Material | Delivered Qty |
Del100 | A | 2 |
Del100 | B | 8 |
Del200 | A | 2 |
Del200 | B | 6 |
<tbody>
</tbody>
Now while creating a query on both tables with Ordered qty and Delivered Qty, results are displayed as below...
Material | Delivery | Order Qty | Delivered Qty |
A | Del100 | 5 | 2 |
A | Del200 | 5 | 2 |
B | Del100 | 10 | 2 |
B | Del200 | 10 | 6 |
<tbody>
</tbody>
i want to avoid repetition in Order Qty column in final output as it gives a wrong image of order qty to be double or multiples of No. of Deliveries.