Apply nested query criteria

[Vbinet1]

Not sure if this can be done. Referencing a field via dlookup in a query but want no criteria applied if the result is 0.

So if dlookup (blah)=0 then give me all results, otherwise just give me the results where they equal the value in (blah).

Am I too far off the mark here?

[June7]

DLookup() returns Null if there is no match.

Is the field a text type?

So try:

LIKE DLookup(...) & "*"