output to a formated excel sheet

[SF]

Hi,

I have a simple query contain several column as below:

Province Project type Number
AAAAA Received 3
AAAAA Approved 1

How can I export this to an excel sheet with a formatted column by joining
the AAAAA province together in one single row and keep the project type as
such or any export to excel need to be manually formatted?

SF

 

[[MVP] S.Clark]

You have two issues. First, the joining of the province records into a
single row. You can use a crosstab query to do this.

Next, the exporting can be done with transferspreadsheet, but you can save a
macro, in Excel, to do other formatting, like Bold, Italics, etc.

 

[SF]

You mean macro in Excel?

SF

You have two issues. First, the joining of the province records into a
single row. You can use a crosstab query to do this.

Next, the exporting can be done with transferspreadsheet, but you can save
a macro, in Excel, to do other formatting, like Bold, Italics, etc.