Hi,
I am trying to create a pivot table in MS Access 2003. I have only two fields in my query and I have inserted [Month] in the Row Area and I have inserted [PO] in the data area .. now access automatically Summing up the PO values .. but I need the count of the POs for the Month..So how do I change the Sum function to Count Function?
SELECT Count([PO]) AS CountofPO
FROM mytables
GROUP BY [MONTH]