Null query Fields

K

K

Good day,

I have a query that sums up information and as an outerjoin to another query
to dsiplay information where there is a match. When there is no match the
field is blank. Is there a way to have the field display a zero persay when
it is blank? Can I use a IF IsNull expression in the criteria field?

Any help would be greatly appreciated.

Thanks in advance.
 
K

KARL DEWEY

You would not use it in criteria but in output field instead of the field
name like this --
New Field Label: IIF([OldFieldLabel] Is Null, 0, [OldFieldLabel])
 
K

K

In what part / proerty of the query?

Phil said:
If the field is [table.field]

use Nz([table.field],0)




Good day,

I have a query that sums up information and as an outerjoin to another query
to dsiplay information where there is a match. When there is no match the
field is blank. Is there a way to have the field display a zero persay when
it is blank? Can I use a IF IsNull expression in the criteria field?

Any help would be greatly appreciated.

Thanks in advance.
Click to expand...
Click to expand...
 
P

Phil

In the field area of the query grid. Instead of seeing 'field' in the
query grid, with 'table' underneath it, put field:nz(
.[field],0)

In SQL you would replace

SELECT table.field

with

SELECT nz(
![field],0) AS field

In what part / proerty of the query?

:

If the field is [table.field]

use Nz([table.field],0)





K wrote:

Good day,

I have a query that sums up information and as an outerjoin to another query
to dsiplay information where there is a match. When there is no match the
field is blank. Is there a way to have the field display a zero persay when
it is blank? Can I use a IF IsNull expression in the criteria field?

Any help would be greatly appreciated.

Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Top