Tutorial :Mystery HAVING clause



Question:

Can anyone please explain the following HAVING clause from an Access database? How can Format with all '0' ever return a string of spaces?

HAVING Format([PerNr],'0000000') <> '       '  


Solution:1

Possible if field value is set to spaces...

VBA:

Dim x As String  x = "       "  MsgBox "x = " & Format(x, "0000000") & " : Len(x) = " & Len(Format(x, "0000000"))  

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »