By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Replace NULL with 0 in Query

P: 3
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.
Dec 14 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
I think what you want is Nz(YourFieldName, 0).

Welcome to TheScripts!

Linq ;0)>
Dec 14 '07 #2

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

Welcome to TheScripts!

Linq ;0)>
And were will i insert this expression?
Dec 14 '07 #3

P: 3
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.
Dec 14 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.