Hi All,
I've got a similar problem to grahampinkney with exporting to csv. I have to export to a csv file so it can be read by other software over which I have no control. Problem is - empty fields need to be shown as "" in the csv file. Each field which has something in it has the quotes as the text qualifier but empty fields have nothing and display as:
             "string","string",,,"string" etc.
I need
             "string","string","","","string" etc.
Yes, I can find and replace consecutive commas with double quotes inserted in the csv file but it won't actually be me that's doing it as an ongoing task so the simpler the solution the better.
Any bright ideas anyone?
Cheers
M

Try the NZ formula on the query to replace blanks with ""