Recent content by aero.space.junkie.1

  1. A

    substitute value for Dlookup() if null is returned

    thanks spike. Yes, that works fine. The coding is a bit tedious, as I just got to this.
  2. A

    substitute value for Dlookup() if null is returned

    I have always disliked NZ() for various reasons. So I've never used it. and thus, never think about doing so. If it really is that simple, I thank you sir! :) that is something that I can use find/replace to put in. Manual labor is not an option with this much coding.
  3. A

    substitute value for Dlookup() if null is returned

    hi all, I am writing lines to a txt from a module. here's a sample line that I have: Write #1, "332: " & DLookup("[STATION IDENT]", "STATIONS", "[STATION IDENT] = 'YYY' AND [REGION] = 'ZZ") & " / #Plans With Reference: " & DCount("[FIX]", "PLANS", "[FIX] = 'AA' AND [REGION] = 'QQ'...
See more
Back
Top Bottom