Relatively new to the forum, but need the benefit of some experience in a problem I cannot resolve.
Simply - I have 3 pre-determined data sources which append to 3 different tables.
Table 1 - Shipment Number
Table 2 - Shipment Number
- Delivery Number
Table 3 -Delivery Number
- Receipt Date Time
Table 1 to Table 2 - joined by Shipment Number
Table 2 to Table 3 - joined by Delivery Number
I want to output the received date/time for each shipment.
Shipment does not exsist in Table 3 and there are multiple deliveries for each shipment.
The received date/time in Table 3 is the same for each delivery on the same shipment.
My query returns duplicate records for the shipment due to having multiple deliveries - how can I filter the results to return just one received date/time for records that have multiple deliveries assigned to a shipment ?
Hope this makes sense - I have tried various options but cannot resolve the issue.
Thanks for your support
Regards
John
Simply - I have 3 pre-determined data sources which append to 3 different tables.
Table 1 - Shipment Number
Table 2 - Shipment Number
- Delivery Number
Table 3 -Delivery Number
- Receipt Date Time
Table 1 to Table 2 - joined by Shipment Number
Table 2 to Table 3 - joined by Delivery Number
I want to output the received date/time for each shipment.
Shipment does not exsist in Table 3 and there are multiple deliveries for each shipment.
The received date/time in Table 3 is the same for each delivery on the same shipment.
My query returns duplicate records for the shipment due to having multiple deliveries - how can I filter the results to return just one received date/time for records that have multiple deliveries assigned to a shipment ?
Hope this makes sense - I have tried various options but cannot resolve the issue.
Thanks for your support
Regards
John