I'm using the Microsoft Access to do the SQL and is there any way for me to set the criteria for the Functions such as COUNT?
I found that the COUNT() Function will count the records where the Captain field meets the requirement too where Pilots.[PilotNum] = Bookings.[Co-Captain] AND Pilots.[PilotNum] = Bookings.[Captain]
The SQL below is the SQL I used to find the number of the Co-captain for each Pilots
The result of my SQL
HOW can I use COUNT() function to count each PilotNum appeared in each column seperately
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)