|
|
How to change query empty field to "0"
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
|
|
0
|
|
|
|
Reply
|
 dolino
|
4/18/2010 2:30:42 PM |
|
On 18 apr, 16:30, "dolino" <u59449@uwe> wrote:
> 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 5=
0
> 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 quer=
y
> (sum: SumOfqueryA) has a problem. 50 fields have result, and 10 field is
> blank because I have 50 results in QueryA. =A0How to change 10 blank fiel=
ds in
> to 0 . Query is uneditable.
>
> I found a lot of instructions, but I failed to do. I need to change the b=
lank
> 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
|
|
|
0
|
|
|
|
Reply
|
XPS350
|
4/18/2010 2:59:09 PM
|
|
Thanks for your help I solved my problem. The problem was in the
relationships of the tables. Stupid mistake.
Thank you again
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1
|
|
|
0
|
|
|
|
Reply
|
dolino
|
4/19/2010 6:21:38 AM
|
|
|
2 Replies
579 Views
(page loaded in 0.164 seconds)
Similiar Articles: How to change query empty field to "0" - microsoft ...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 ... adding empty spaces to fields? - microsoft.public.access.queries ...How to change query empty field to "0" - microsoft ... adding empty spaces to fields? - microsoft.public.access.queries ... How to change query empty field to "0 ... Query criteria: field is empty - microsoft.public.access ...How to change query empty field to "0" - microsoft ... How to change query empty field to "0" - microsoft.public.access ... Access Tips: Query and Filter Criteria Finding ... Change Query Field Name - microsoft.public.access.queries ...How to change query empty field to "0" - microsoft ... How to change query empty field to "0" - microsoft ... Change Query Field Name - microsoft.public.access.queries ... Find/Replace an empty field - microsoft.public.accessHow to change query empty field to "0" - microsoft ... Find/Replace an empty field - microsoft.public.access How to change query empty field to "0" - microsoft ... If query/subform is empty set calculation value to 0 - microsoft ...How to change query empty field to "0" - microsoft ... If query/subform is empty set calculation value to 0 - microsoft ... How to change query empty field to "0 ... update query to remove parenthesis - microsoft.public.access ...How to change query empty field to "0" - microsoft ... update query to remove parenthesis - microsoft.public.access ... How to change query empty field to "0" - microsoft ... how do I surpress the printout of an empty field and its label ...How to change query empty field to "0" - microsoft ... how do I surpress the printout of an empty field and its label ... Can't have a null value if another field has text ... Replace blank fields with 0 - microsoft.public.access.reports ...How to change query empty field to "0" - microsoft ... I need to change the blank field at 0 If someone can explain where I need to ... Find/Replace an empty field ... IIf statement in query, Null value change to "0" ...... my query returns null I need to do math on the returned value ... I use the IIF statement, eg IIF([good]>0, [good], 0 ... How to change query empty field to "0 ... How to change query empty field to "0" DataBaseHello, At the beginning forgive me at the bad English. I am a beginner in Access. I am working on a database that deals with records warehouse. To simpli How to change query empty field to "0" - microsoft ...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 ... How to Query Microsoft Access for a Blank Field | eHow.comHow to Query Microsoft Access for a Blank Field. An empty field in a database ... like running a filter on your query results. For example, if... How to Change Blank Fields ... adding empty spaces to fields? - microsoft.public.access.queries ...How to change query empty field to "0" - microsoft ... adding empty spaces to fields? - microsoft.public.access.queries ... How to change query empty field to "0 ... How to modify query properties in Microsoft Access... value queries,add an alias for a table,change field ... of any query, right-click in an empty space in the query ... By setting this property to zero (0), no ... 7/28/2012 11:56:17 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
16 followers. 