I have a table (generated from a maketable query) with the following fields :
Standard Time of Arrival (STA)
Hour of Arrival (retrieved with Hour function)
Standard Time of Departure (STD)
Hour of Departure
What I need to obtain is the number of deplaned and enplaned passengers per hour:
Hours (unique values of Hour of departure combined with hour of arrival)
I have spent time on it and googled it for hours but I haven't found a solution for my problem.
I have tried a query like :
SELECT tblFlightDate.Hour_STA, Sum(tblFlightDate.Average_DePax) AS Deplanements, Sum(tblFlightDate.Average_EnPax) AS Enplanements
GROUP BY tblFlightDate.Hour_STA;
This query has the format that i want but doesn't give me all hours and all enplaned passengers since i only select hours of arrival.
It doesn't look that I hard but I haven't been able to figure out how to make it work.