Search results

  1. M

    Access query calculation which gives #n/a

    ps! just to let you know. IsError () is also in use in Access.
  2. M

    Access query calculation which gives #n/a

    When the there is no match between two tables (i.e. a specific customer ID) this appear in the output when running the query (#N/A è ‘not avilable’). Then I want it to write “Unknown business” instead. M.-)
  3. M

    Access query calculation which gives #n/a

    Anyone who know how to display a "selected text" (i.e "Unknown business") when data from Access query calculation shows "#n/a"? I've tried this: Branch title: IIf(IsNull([Branchtitle]![Branchtitle]),"Unknown business",IIf(IsError([Branchtitle]![Branchtitle]),"Unknown...
Back
Top Bottom