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

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

Guest

Some of the cells in my table are empty. If they are empty I want to
replace them with a value of zero.
 
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
..
 
Back
Top