I have a form that will post the daily expenses. This form takes the records
from the query.
In the query I have set the citeria for date range. During the citeria filter,
there are dates without expenses records. When there is totally no records on
the selected date range, my form subtotal will appear blank. Is it possible
to appear 0 instead of blank.
Thank you
Syphonics - 08 May 2008 12:22 GMT
By using Nz i could not get it fix as well.
=Nz([Debit],0)
Still i get no records
>I have a form that will post the daily expenses. This form takes the records
>from the query.
[quoted text clipped - 4 lines]
>
>Thank you
Syphonics - 10 May 2008 01:37 GMT
Anyone out there able to help me on this?
Should I do something on my query or form?
>By using Nz i could not get it fix as well.
>
[quoted text clipped - 7 lines]
>>
>>Thank you