Replace function in vba

[Ben_Entrew]

Hi all,

how can I check if a table contains blank fields/values.

If there are blank fields I want to replace them with 0.

Can someone help me out here?

Thanks in advance.

Regards,
Ben

 

[pr2-eugin]

Is Null in SQL Query will give you the result.

SELECT * FROM theTable 
WHERE theField IsNull;

 

[Ben_Entrew]

Hello Paul,

thanks for your reply.

How can I check for all columns, blank values can appear in different month columns.
I need to check every column if a blank value exists.

Regards,
Ben

 

[Simon_MT]

Put a Default value of Zero on the fields that you do not want as Null.

Simon

 

[Ben_Entrew]

Thank Simon.

Now it works out.