Z ZAPPER Dec 31, 2008 #1 In doing an export, I need to have null fields show quotes. Example... ,"data", "test","","","moredate" Can anyone help with this?
In doing an export, I need to have null fields show quotes. Example... ,"data", "test","","","moredate" Can anyone help with this?
D Douglas J. Steele Dec 31, 2008 #2 Create a query, and rather than showing the field, use a calculated value of Nz(MyField, """"""") (That's 6 double quotes in a row.) Export the query, not the table.
Create a query, and rather than showing the field, use a calculated value of Nz(MyField, """"""") (That's 6 double quotes in a row.) Export the query, not the table.