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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top