Recent content by Mort10
-
M
Access query calculation which gives #n/a
ps! just to let you know. IsError () is also in use in Access. -
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.-) -
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...