Access query calculation which gives #n/a

[Mort10]

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 business",[Branchtitle]![Branchtitle]))

It almost went well... though the 'Iserror' function do not return "Unknown business" but the text/value "Unknown" in the data field (instead of "#n/a"), as this function only verify whether a statement is true or false. Is there any way I can direct it to write/give the text "Unknown business". Or maybe there is an option / workaround I missed out?

-------

M.-)

 

[Alansidman]

IsError is an Excel Function. What is causing your #n/a to be returned in a query? I've seen #name, #error, but don't recall seeing a #n/a in Access. I could be wrong, but ......

Alan

 

[Mort10]

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.-)

 

[Mort10]

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

 

[Alansidman]

thanks for letting me know that the IsError function exists in Access. Always learning here. Anyway, I did a little bit of googling and found this thread which may be helpful.

http://groups.google.com/group/micr..._thread/thread/1047229dd12aebf6?pli=1&safe=on