Oh, it imported the Type as text because I just accepted default. I changed it to number, then I modified the query to get rid of nulls.
Sorry for the inconsistency. I just left this as tblFile.TRANSFORM Count(tblFile.Type) AS CountOfType SELECT tblFile.Type, Count(tblFile.Type) AS [Total Of Type] FROM tblFile WHERE IsNull(tblFile.Type)=False GROUP BY tblFile.Type ORDER BY tblFile.Type PIVOT Format([Opened],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");