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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making null 3
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Data/Values change when Query Analyzed in Excel 3
Populating null field in queries 8
Data changes when Analyzed with Excel 2
How to query 2 tables and then perform a wildcard search using a 3 1
query criteria Not Like ... <> 2
selecting union query results 7

Back
Top