Patrice Béliveau wrote:
> Hi,
>
> I have two table, one is containing a dated list of delivery to do and
> the second contain a list of delivery done.
>
> ex: Table 1 --> Order No,
> Delivery date requested,
> Quantity requested
>
> Table 2 --> Shipping No.
> Order No.
> Date shipped
> Quantity shipped
>
>
> They are not into the same list because there is no one on one
> relation between those two list (ex: some delivery might have been
> back order, or that might have been some over shipment, etc...)
>
> The QUESTION:
>
> what query can I do to known where am I at in my delivery schedule?
>
> Thanks
what is your question?
How many deliveries you've done? what's the most recent delivery done?
what is the nearest (min) date of a delivery yet to do? How many
deliveries yet to do?
Received on Thu Nov 04 2004 - 15:39:31 CST
