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

D

Diane P

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

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