DLookUp Question

[Ramma2]

I'm using DLookUp in one of my reports, I'm just wondering if there is a way to make it not return #Error if there is no value for a certain field.

Any Ideas?

 

[The_Doc_Man]

Doesn't have a value?

There could be two ways this happens.

1. Value is a null. Fix by retrieving, not [ABC], but Nz([ABC],0) or Nz([ABC],"") as appropriate for the field type.

2. Matching record doesn't exist. Before doing the DLookup, do a DCount to verify you have at least one record.