Solved

Access Column

Posted on 2013-07-01
1
336 Views
Last Modified: 2013-07-01
I want to find the first blank (null) value in a table column and replace it with 0 (zero) Any Thoughts --- Thanks
0
Comment
Question by:shieldsco
1 Comment
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39291372
Assuming that your table is in a detectable order - such as with an auto number ID, you can use this UPDATE query:


UPDATE YourTable
SET YourField = 0
WHERE ID = DMin("ID", "YourTable", "YourField IS NULL")

Open in new window


Note that if you do not have an autonumber, date field or some other way to identify the order of the records, then it is impossible to reliably find the "First" Null in your table.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question