Please help me with sql code

  • Thread starter Thread starter alr7al
  • Start date Start date
A

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
 
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;
 
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
 
Back
Top