How Populate empty fields with zeros..

[adrian]

Hi ,

I have the following simple table:

Name Appointment Salary
********************************
Adrian Manager $2000
Daisy Secretary $1500
Simon Volunteer (empty)


I need to write create a query that will produce the following

Name Salary
***************
Adrian $2000
Daisy $1500
Simon $0

How do I go about creating a query that will insert a zero value for blank
fields ... ?
Thanks.

Regards,
Adrian

 

[Ofer]

Try and use the NZ function, to replace null with 0

Nz(FieldName,0)

 

[Dale]

Try this:

UPDATE Table Name SET Table Name.[Salary] = "$0"
WHERE (((Table Name.[Salary]) Is Null));

Let me know if it works.

Dale