Replace NULL with 0 in Query

[IRON77]

Hello Experts,

I'm a noob in access and would like to do the following in access2003:

I have tree tables A, B, C. Table A is master table and as unique ID for each line. Table B and C have data that is complement to table A.

Table B and C have a type 2 relationship with table A throw the unique id number in table A.

What happens is that in table B and C i don't have all the unique ID's from table A so wen i do a query with this 3 tables i get some Null Fields. What i would like to do is insert in those NULL fields the 0 character.

Do you think this is possible?

Tanks in advance for all the help.

[missinglinq]

I think what you want is Nz(YourFieldName, 0).

Welcome to TheScripts!

Linq ;0)>

[IRON77]

I think what you want is Nz(YourFieldName, 0).

Welcome to TheScripts!

Linq ;0)>

And were will i insert this expression?

[IRON77]

And were will i insert this expression?

I figured it out. Tanks Linq.

Now i have another problem. I want to Sum the values from Table B and Table C and instead of summing the result access is joining the values from Table B and Table C ( Ex. Table B: 10; Table C: 5 - Result expected: 15 - Result experienced: 105 )

I tried to Format the field to Numeric but in properties format there is no option available. Please help.

Once again thank in advance for the answers you may have to resolve this issue.

Sorry for my bad English.