How to find the most popular info. using a query

[Lordwillin]

Hi,
I am doing a database for my MIS Project and my memory of access is quite outdated. In one of my tables i have a field by the name of CFC, which holds flight info for my database e.g. AA-432 (American Airline flight 432)

I want to do a query that will pull up the most popular airlines used, based on the values in the CFC field.

This is how far i got with my query in SQL view

SELECT WBASS.TicketNumber, [FirstName]+[LastName] AS Name, WBASS.CheckInDate, WBASS.CheckOutDate, WBASS.TentativeReturnDate, Count(WBASS.CFC) AS CountOfCFC
FROM WBASS
GROUP BY WBASS.TicketNumber, [FirstName]+[LastName], WBASS.CheckInDate, WBASS.CheckOutDate, WBASS.TentativeReturnDate;