I have created a report to present the result of a query. But if the query returns nothing, one of the textfields return "#Error" in printview, and "" in reportview, and I can't figure out why this happens.
In the controlsource property I have written the following:
[Gnsntimeløn md] is part of the basic query for the report.
Can any of you explain to me why this happens? And perhaps how I can avoid this? The #Error-message looks somewhat disturbing...
In the controlsource property I have written the following:
Code:
=Round((DLookUp("Kontakttimer";"KontakttimerAdm"))*([Gnsntimeløn md]))
Can any of you explain to me why this happens? And perhaps how I can avoid this? The #Error-message looks somewhat disturbing...
Comment