I have been working on a CSV export of a query, my problem is that
I need a header row like in a Report.
Any guidance would truly be appreciated........ :)
My query provides:
month,year,amount,event,activity,accountnumber
I need a header row as follows
=Count(*), =Sum([amount]),event,activity
so the resulting text file will look like:
=Count(*), =Sum([amount]),event,activity
month,year,amount,event,activity,accountnumber
month,year,amount,event,activity,accountnumber
month,year,amount,event,activity,accountnumber
etc
(export specification is set so that " text qualifiers are NOT
allowed)
resulting file cannot have any spaces between CSV fields (as with a
Report export)
Header at top, no footer
One record on each line
Access 2002 XP SP2