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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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))
 
Back
Top