Expression returns blank rather than zero

[mr tom]

Chaps,

I've got the following expression (in a form):

=DLookUp("[Count]","WeeklyWFReport","[ReportGroup]=5")

When there is nothing to return, rather than returning a zero, it returns
nothing.

Unfortunately, this messes up validation and calculations further down the
lines.

Anybody know how I can get around this?

Cheers.

 

[Allen Browne]

Use Nz() to convert the Null into the desired value:

=Nz(DLookUp("[Count]","WeeklyWFReport","[ReportGroup]=5"), 0)

 

[mr tom]

Allen,

Thank you so much.

Was messing about with that for ages!

Cheers,

Tom.

Use Nz() to convert the Null into the desired value:

=Nz(DLookUp("[Count]","WeeklyWFReport","[ReportGroup]=5"), 0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Chaps,

I've got the following expression (in a form):

=DLookUp("[Count]","WeeklyWFReport","[ReportGroup]=5")

When there is nothing to return, rather than returning a zero, it returns
nothing.

Unfortunately, this messes up validation and calculations further down the
lines.

Anybody know how I can get around this?

Cheers.