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, [FirstName]+[LastName] AS Name, WBASS.CheckInDa te, WBASS.CheckOutD ate, WBASS.Tentative ReturnDate, Count(WBASS.CFC ) AS CountOfCFC
FROM WBASS
GROUP BY WBASS.TicketNum ber, [FirstName]+[LastName], WBASS.CheckInDa te, WBASS.CheckOutD ate, WBASS.Tentative ReturnDate;
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, [FirstName]+[LastName] AS Name, WBASS.CheckInDa te, WBASS.CheckOutD ate, WBASS.Tentative ReturnDate, Count(WBASS.CFC ) AS CountOfCFC
FROM WBASS
GROUP BY WBASS.TicketNum ber, [FirstName]+[LastName], WBASS.CheckInDa te, WBASS.CheckOutD ate, WBASS.Tentative ReturnDate;