Expression returns blank rather than zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mr tom - 17 Jul 2007 11:52 GMT

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.

Reply to this Message

Allen Browne - 17 Jul 2007 11:57 GMT

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

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Chaps,
>
[quoted text clipped - 11 lines]
>
> Cheers.

Reply to this Message

mr tom - 17 Jul 2007 12:12 GMT

Allen,

Thank you so much.

Was messing about with that for ages!

Cheers,

Tom.

> Use Nz() to convert the Null into the desired value:
>
[quoted text clipped - 15 lines]
> >
> > Cheers.

Reply to this Message