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

=Nz([Debit],0)

Still i get no records



Syphonics wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200805/1