>Dear Expert
>
>Table1 has two fields as
>date d(8)
>no n(1)
>
>Field no has numbers from 1 to 9
>I am making a SQL to sum different type of vehicles.
>
>Please make following SQL enable to show correct data
>
>

>select date1,;
>	sum(iif(no = 1, no, $0)) as truck,;
>	sum(iif(no = 2, no, $0)) as trolly,;
>	sum(iif(no = 3, no, $0)) as troller,;
>	sum(iif(no = 4, no, $0)) as ttroler,;
>	sum(iif(no = 5, no, $0)) as tanker,;
>	sum(iif(no = 6, no, $0)) as bcart,;
>	sum(iif(no = 7, no, $0)) as ccart,;
>	sum(iif(no = 8, no, $0)) as dcart,;
>	sum(iif(no = 9, no, $0)) as other,;
>	count(no) as veh,;
>	from table1;
>	group by 1;
>	into table tmp
>

What exactly didn't work? This SELECT looks fine to me?