simple query

[NewStudent]

Hi, All,

The following are my queries:

SELECT [Complaints].[mode] AS Category, count([mode])*100/sum([mode]) AS Percentage
FROM Complaints
WHERE [complaints].[mode] Is Not Null
GROUP BY [mode];

I want to get percentage group by 'mode', but it is not work. In this case, the 'mode' 's data type is "text". I try to change the data type for 'mode'that I may lost lot of data.

Any help? Thank you very much.

Rong

 

[tlbroadbent]

Try this.

SELECT [Complaints].[mode] AS Category, count([mode])*100./DCount("*", "Complaints","[Mode] Is Not Null&quot AS Percentage
FROM Complaints
WHERE [complaints].[mode] Is Not Null
GROUP BY [mode];
Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[NewStudent]

Hi, Terry,

I got. Thanks again.
Rong