Manual export query to excel with known blanks

[SidCharming]

I run my query and have no issues. I click the export to Excel button in Access 2002. Everything transfers into a new excel workbook. I noticed one thing different was the date format... Access shows m/d/yy and Excel shows the same column with d-mmm-yy formatting, a minor issue. Easy to correct with select column and change formatting.

The pain is I have numerous known blank fields that when I do column calculations those fields contain a "" value not null. So if I do a countif(whole column) I get the number of items in my column including blank fields.

Any insight to this? It seems to not care if integer or string data type.



Sid from Minnesota

 

[SidCharming]

Anyone have any thoughts on this?



Sid from Minnesota

 

[hymn]

I assume that the information in the db is being inputted into the db, then selected data is being transferred to excel? Why not make the default value in the table 0 then there should not be any blank fields.

Hope this helps
Hymn

 

[SidCharming]

The data I am collecting is for clinical studies. I really want to keep blank places. If there is a value that is a default to 'null' or 'No Answer (NA)' or the like I have to perform a search & replace the default numerical value to a statement from previous sentance. Ends up being additional time that is unnecessary spent.

thanks for the reply!



Sid from Minnesota