?
Solved

Null Field Equals Zero In Access

Posted on 2007-12-03
4
Medium Priority
?
448 Views
Last Modified: 2012-06-21
I have an Access table with 4 columns  I am using an expression to sum two of the columns to update my totals columns.  However  I need to populate the null fields of one of the columns that is being summed with zero so the math will work.  How can that be done?  Thanks.
0
Comment
Question by:submarinerssbn731
  • 2
4 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 200 total points
ID: 20396328
Nz(YourColumnNameGoesHere, 0) will convert any null values to zero.

0
 
LVL 16

Expert Comment

by:Rick_Rickards
ID: 20396345
SELECT Nz(Field1,0), Nz(Field2,0), Nz(Field3,0), Nz(Field4,0) FROM tblMyTable;
0
 
LVL 16

Expert Comment

by:Rick_Rickards
ID: 20396357
Smile, looks like Jim beat me to the post.
0
 

Author Closing Comment

by:submarinerssbn731
ID: 31412359
It did convert the null fields to zero but the query only returned the records with null fields.  I want to return all rows when I run the query.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

615 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