Exporting a database to CSV

[Guest]

I am exporting a Query I did with CSV, there are certain fields in the
QUERY That I don't want to export but need for the Query how do I make the
export wizard not export those fields? for instance I have fields called A,
B, C, D, becuase one field called Description is A + B + C + D in the query,
therefore I don't need to export A, B, C, and D but I need them as one field
called Description.

Thank you,

 

[Steve Huff]

I'm not sure I follow you 100% (or even close to that). If you export a
query to CSV text it will only export the fields that the query returns - if
the query needs to return more fields in one case then in the export case
then simply make a copy of that query with a different name and use that
copy to export with less fields.

--Steve Huff

 

[Guest]

No the export needs to export less fields than query, but the export wizard
only allows me to export ALL the fields not just select a few from the QUERY

 

[Guest]

In the query Design, deselect the "Show" checkbox for the fields you don't
want. They will still be there to calculate from, but won't show in the
report.