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.TicketNum ber,...