How to change query empty field to "0"

[dolino]

Hello,
At the beginning forgive me at the bad English. I am a beginner in Access.

I'm working on a database that deals with records warehouse. To simplify the.


I have one query, for example query A, a query where the calculation of 50
items. This query A has sum by the code of materials. The second query is
composed of one few table and query A. But in this table is 60 items with the
calculations of other tables. The column, which is associated with a query
(sum: SumOfqueryA) has a problem. 50 fields have result, and 10 field is
blank because I have 50 results in QueryA. How to change 10 blank fields in
to 0 . Query is uneditable.

I found a lot of instructions, but I failed to do. I need to change the blank
field at 0 If someone can explain where I need to write code.

Thank you very much and please help me

 

[XPS350]

Hello,
At the beginning forgive me at the bad English. I am a beginner in Access..

I'm working on a database that deals with records warehouse. To simplify the.

I have one query, for example query A, a query where the calculation of 50
items. This query A has sum by the code of materials. The second query is
composed of one few table and query A. But in this table is 60 items withthe
calculations of other tables. The column, which is associated with a query
(sum: SumOfqueryA) has a problem. 50 fields have result, and 10 field is
blank because I have 50 results in QueryA.  How to change 10 blank fields in
to 0 . Query is uneditable.

I found a lot of instructions, but I failed to do. I need to change the blank
field at 0 If someone can explain where I need to write code.

Thank you very much and please help me

Instead of the field name write: Nz(FieldName,0)

Groeten,

Peter
http://access.xps350.com

 

[dolino via AccessMonster.com]

Thanks for your help I solved my problem. The problem was in the
relationships of the tables. Stupid mistake.

Thank you again