Skip to Content
0
Former Member
Feb 19, 2009 at 04:26 PM

Count() in query to be exported in Excel

40 Views

Hi there,

Can count() column be exported in Excel?

By that I mean, for example

I created a query

 SELECT count(T0.[DocNum]), T0.[CardCode] FROM OPOR T0 GROUP BY T0.[CardCode] 

Obviously, there are 2 columns plus "#". But when I have exported the result table into Excel, the count()column didn't show.

Has anyone encountered this before?

Many thanks