If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
shown blank in form after citeria filter in query
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 http://www.accessmonster.com |
#2
|
|||
|
|||
shown blank in form after citeria filter in query
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 |
#3
|
|||
|
|||
shown blank in form after citeria filter in query
Anyone out there able to help me on this?
Should I do something on my query or form? Syphonics wrote: 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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|