Greetings,
I am very new to working with databases, and I am not sure how to go about structuring the query I need. What I have is an Access database with approx. 400,000 records in 5 fields. The fields are owner, filename, size, path, modified date. What I would like to do is take the field "filename", and come up with a count of the different file types listed in the records (XLS, PPT, DOC, etc...) as well as a sum of the...