I'm using Access 2003 and have an issue with getting a zero value from a query (or) form that has no records. It works great as long as there is at least 1 record but not for a 'no record' issue.
I've used Nz; IIf, and IsNull and the codes work providing i have at least one record with data in it, but I need it to show as a 'zero' if there are no records showing in the table
This is for a form, or query and is the end result from a Sum([---]) equation
any help would be greatly appreciated
1. This code gives me a Zero but if there is data available, it still shows a zero and doesn't take the real value (i.e. $35.85) =IIf([Daily WO Query-mastercard].[Form]![TotalPayment],"0","")
2. This one will show a vaue if it has one, but an error is it doesn't: =IIf([Daily WO Query-mastercard].[Form]![TotalPayment],([Daily WO Query-mastercard].[Form]![TotalPayment]),"0")
-
I've used Nz; IIf, and IsNull and the codes work providing i have at least one record with data in it, but I need it to show as a 'zero' if there are no records showing in the table
This is for a form, or query and is the end result from a Sum([---]) equation
any help would be greatly appreciated
1. This code gives me a Zero but if there is data available, it still shows a zero and doesn't take the real value (i.e. $35.85) =IIf([Daily WO Query-mastercard].[Form]![TotalPayment],"0","")
2. This one will show a vaue if it has one, but an error is it doesn't: =IIf([Daily WO Query-mastercard].[Form]![TotalPayment],([Daily WO Query-mastercard].[Form]![TotalPayment]),"0")
-
Last edited: