If the Nz() hierarchy does not get what you want then I guess will need the custom function offered by ranman. Put the function procedure in a general module.
If the Nz() hierarchy does not get what you want then I guess will need the custom function offered by ranman. Put the function procedure in a general module.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.