#Error due to empty query (1 Viewer)

[teknogeek9]

I have a report which combines the results of a query with "test". For example,
=RTrim([CS or Inst]) & " Employment/Affirmative Action Personnel Changes"

There are times when the query does not return any records and because of such, #Error will display.

How can I prevent #Error and instead, print just Employment/Affirmative Action Personnel Changes.

Thanks!

 

[Richie]

Iif (IsNull([CS or Inst], " Employment/Affirmative Action Personnel Changes",RTrim([CS or Inst]) & " Employment/Affirmative Action Personnel Changes"))

 

[teknogeek9]

Thanks Rich!