A
Alchemist61
I am running a query based on two tables and have created the outer left join
relationship in the query which works beautiful.
when I run the Query, It returns Quantity Shipped this month and Quantity
shipped todate. If an item does not shipped in this month, it would return a
blank field in the Query. Can you help me to create an Expression in the
Query Criteria that would convert only the Blanks into Zeros? Please make it
simple for a beginner.
Thank You.
relationship in the query which works beautiful.
when I run the Query, It returns Quantity Shipped this month and Quantity
shipped todate. If an item does not shipped in this month, it would return a
blank field in the Query. Can you help me to create an Expression in the
Query Criteria that would convert only the Blanks into Zeros? Please make it
simple for a beginner.
Thank You.