Output quotes if theres a blank field 1

[MikeGeitner]

I'm using the TransferText method to create a .csv file from the results of a query. If there are any empty fields in the table there has to be double-quotes between the commas in that .csv file. Anybody know how I can add the quotes in the query?


The file has to look like this:

"something","something","","","",""

 

[PHV]

Use the Nz function in your query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886