displaying a message on the report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have generated a report basing on a query which gives me the
number of cases and trying to display the same on the report. But what I want
to do is, if the number of cases are less than 5, I want to display as "not
sufficient data" on the report.

for this to accomplish I have written a code as follows in the On Open
function of the report:

If [TotalCases] <=5 then
[TotalCases] = "not sufficient data"
End If

when I try to open the report, it shows a problem with the code! which is
the best way to accomplish this task.

thanks for any help
talktobatchu.
 
If TotalCases is a number field, you can't place text ("not sufficient
data") into it.
You could place an unbound text control alongside TotalCases with...
= IIF(TotalCases < 5, "Insufficient Data",""
hth
Al Camp
 
Back
Top