Output "Text","Text","Number"

[Garry]

Hi all

I am required to output a report to a comma delimited csv file.

This report containes summing over group and cumulative over group output

All text and NUMBERS should be enclosed with " "

I am getting the following as an example :-

"Text","Text",Number

I need

"Text","Text","Number"

any ideas please, cheers

 

[Al Campagna]

Garry,
Just a shot in the dark... but, it won't take but a moment to test.
Try...
Str(Number) ' for deatil values
and
Str(Sum(Number)) ' for footer sums
on your report.

No guarantees...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."