shown blank in form after citeria filter in query

  • Thread starter Syphonics via AccessMonster.com
  • Start date
S

Syphonics via AccessMonster.com

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
 
S

Syphonics via AccessMonster.com

By using Nz i could not get it fix as well.

=Nz([Debit],0)

Still i get no records
 
S

Syphonics via AccessMonster.com

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.

=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
 
Top