Exporting a database to CSV

M

Marc

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,
 
S

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
 
M

Marc

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
 
G

George King

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.
 
Top