Exporting results of a report to a CSV file

[khinester]

Hello,
I am not sure if this is the correct way to do this, but
I am unable to find how to do it?

I have a query that has the following SQL statement:

SELECT [TblSubscriptions].[CompanyName], 1 AS Expr1, [Tbl
TblSubscriptions].[Multiple]
FROM [TblSubscriptions]
WHERE ((([TblSubscriptions].[Multiple])=1))
ORDER BY [TblSubscriptions].[CompanyName];

This basically I guess flags "1" for each companyName it
finds.

Now on my report, I have grouped all by companyName and
have for one of the fields in the Control Source =Sum
([Expr1])

So, now I get a summary of how many Duplicate names I
have of each name.

My question, is it possible to export this report into
another access table, if so how would one do this?

Thanks