SidCharming
Technical User
I have a query that displays blank (null) fields. When exporting to Excel these fields still display as blank, but when I perform column counts [countif(range,"*")] it counts even the blanks.
Why does Excel import with a value of something other than blank as in Access?
Is there a good solution to make this not happen? I have to visit each 'blank' cell hit (DEL) and it becomes 'blank' and my count works.
Arggggg this is a pain when I have a lot of data!!
Sid from Minnesota
Why does Excel import with a value of something other than blank as in Access?
Is there a good solution to make this not happen? I have to visit each 'blank' cell hit (DEL) and it becomes 'blank' and my count works.
Arggggg this is a pain when I have a lot of data!!
Sid from Minnesota
