IIF statement

  • Thread starter Thread starter Steve G
  • Start date Start date
S

Steve G

Hi again:

I am trying to create a report in Access that shows the record count of a
recordset derived from a query based on specific criteria. This works all
right, provided that there are records that meet the criteria. However, if
there are no records that meet the criteria specified, when I run the query,
the view simply returns the header, with no field under it, and consequently
no count. I need to have a count of 0 to appear there. I've tried running
the following code from the query but it yields the same results:
Count: IIf(IsNull([CountOfPatientStatus]),0,[CountOfPatientStatus])

I've also tried creating a new query, based on the original query, with the
above expression being the only item in the query, and get the same
results...the header is displayed, but nothing under it.

Any ideas or help would be very much appreciated.

Steve G
 
On the OnFormat event, why not set an unbound text box to be the value you
want.

If IsNull([CountOfPatientStatus]) then
me.TextBox.Value = 0
else
me.TextBox.Value = [CountOfPatientStatus]
end if

Kee the [CountOfPatientStatus] as it is but make it hidden
 
Back
Top