Search results

EXCELLENT - both ways work! I tried both ways and I've been able to each of them to work. I did not know about the TRANSFORM and PIVOT components nor had I used the 'SUM(Iif(' command!! THANKS to both of you... I've learned 2 new things today!

I have the detail data in a query working fine in MSAccess 2000 sp3 and I'm trying to create a summary of the data. My query is as follows: SELECT CUH.CULevel, CUH.AREA, TYPES.Asset, Count(TYPES.Asset) AS Counts FROM (TYPES LEFT JOIN Broker ON TYPES.[Owner/LastLogin] = Broker.LOGIN_ID) LEFT...