How do I Convert Columns empty cells to 0 in Update Table Query

[Guest]

Some of the cells in my table are empty. If they are empty I want to
replace them with a value of zero.

 

[PatdeLux]

Some of the cells in my table are empty. If they are empty I want to
replace them with a value of zero.

Use function NZ:
NZ(expression,value if Null)

www.idevlop.com

 

[John Spencer]

UPDATE YOURTable
SET YourField = 0
WHERE YourField Is Null

In the query grid,
-- Select your table
-- Drag your field to the grid
-- Select Query: UPdate from the menu
-- Set Update to Zero
-- Set criteria to Is Null
-- Select Query: Run from the menu

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..