Please help me with sql code

[alr7al]

Hi there,



It's simple code but I got some problem with it, this is the code:-



==========



TRANSFORM Count(cars_info.ID) AS CountOfID

SELECT cars_info.[car type], Count(cars_info.ID) AS [Total Of ID]

FROM cars_info

GROUP BY cars_info.[car type]

PIVOT cars_info.site;



==========



I want to put 0 or - in the two fields which in red

And this is the picture of it in view mode:-



http://www.alr7al.net/Image1.JPG



That is all.

thanx

 

[Duane Hookom]

Try:
TRANSFORM Val(Nz(Count(cars_info.ID),0)) AS CountOfID
SELECT cars_info.[car type], Count(cars_info.ID) AS [Total Of ID]
FROM cars_info
GROUP BY cars_info.[car type]
PIVOT cars_info.site;

 

[alr7al]

Tank you very much.



That's it.



Thank you.

 

[John Sykes]

Hello,

Can someone show me the correct syntax to run a report
called "Mailing List" from a Combo box.

I also need to know what to put in "RowSource"
and "RowSource Type" sections.

Thanks in advance..

John Sykes