To set a null field to numeric in a query linking two tables (Th.

R

RAJ

sThrough a query, I am linking two table, REQUIREMENT and ORDER with a unique
part no. For items, which are not ordered, the order qty is null and not
zero. How to make this as zero, so that I can use this query for filtering &
summarizing.
 
A

Allen Browne

Use Nz().

In query design view, enter this into a fresh column in the Field row:
Quantity: CLng(Nz([Order Qty], 0))

If you have fractional numbers, use:
Quantity: CDbl(Nz([Order Qty], 0))
 
Top