Null query Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 
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...
 
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...
 
Back
Top