I have a table with the following fields: ID#, Name, Date, Service. There are no primary keys so values can be repeated. The values for Service can be: tuneup, lube, oil, checkup. The format of the database can't be changed.<br>I now need to develop a report that lists each Name with the number of each type of service as followssorry if tabs are bad)<FONT FACE=monospace><br>Name Tuneup Lube Oil Checkup<br>John 2 0 1 1<br>Sue 0 0 5 2<br>etc.<br></font><br>Is there any way this can be accomplished through queries or SQL? Should I try modules in a report? So far with SQL I can generate a report by name and group but not formatted as desired:<FONT FACE=monospace><br>Name<br>John<br> Tuneup 2<br> Lube 0<br> Oil 1<br> Checkup 1<br>Sue<br> Tuneup 0<br>etc.<br></font><br>Any suggestions would be greatly appreciated. I don't have much hair left!<br>