i have a query that count how many orders a user ordered. i want but to display zero if its null so i did another query that do nz(resualt,0)
but it didnt worked.
why?
Novice
Windows 7 64bit 
Access 2010 64bit
i have a query that count how many orders a user ordered. i want but to display zero if its null so i did another query that do nz(resualt,0)
but it didnt worked.
why?
Administrator
Windows 7 64bit Access 2010 32bit
Maybe your value was *not* null but "".
Novice
Windows 7 64bit Access 2010 64bit
"" doesnt work i did iif([resualt]="",0,[resualt])
Administrator
Windows 7 64bit Access 2010 32bit
What are you expecting when you turn nulls into 0? What does it return?
Posting Permissions
Reply With Quote