Search results
-
U
Need help with Nz() or IIf() to get a zero value
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...