Blanks fields to zeros???

[PQTIII]

I added a number field to a record , but it shows blanks in the table for the old records. Is there a way to convert all of those blank fields to show 0 without putting a zero in each field by hand?

Thanks
pt

 

[fneily]

Create an Update query on that field. In the Update To row, under the field, put:

IIf([total] Is Null,0,[total])

Substitute [total] for your field name.

 

[PHV]

SQL code:
UPDATE yourTable SET [your number field]=0 WHERE [your number field] Is Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PQTIII]

Where and how do you do the update code?

Thanks
pt

 

[lespaul]

change the query view from Design Grid to SQL


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PQTIII]

I've never done an update before! If have table 'SurveyPoints' and want to update the field [elevation] that contain nulls with zero. How would I write that statement?

Thanks
pt

 

[PHV]

UPDATE SurveyPoints SET [elevation]=0 WHERE [elevation] Is Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PQTIII]

worked perfect!!!

Thanks
pt