A
Alchemist61
Hi Guys,
I need some help with a Query I am running from two seperate tables. One
column has Quantity shipped to date and another column has quantity shipped
this month. If a particular item did not shipped this month, it will not show
up in the Quantity shipped to date column although this item was shipped
previously. I do not know how to set the formula in the criteria row to
return a zero for the month this item was not shipped and the running
quantity to date in the other column. Please Advice.
I have tried the join properties with no success.
Thanks
I need some help with a Query I am running from two seperate tables. One
column has Quantity shipped to date and another column has quantity shipped
this month. If a particular item did not shipped this month, it will not show
up in the Quantity shipped to date column although this item was shipped
previously. I do not know how to set the formula in the criteria row to
return a zero for the month this item was not shipped and the running
quantity to date in the other column. Please Advice.
I have tried the join properties with no success.
Thanks