Creating my own Queries??


New member
Jun 6, 2007
I am coming up on a CFI checkride soon, and was filling out the wonderful 8710 form. On the form it asks to fill in my hours. Some of the things they request on the 8710 form are:
x-c dual, x-c solo, x-c PIC, nite dual, nite PIC and so on.

Is there a way to possibly create my own queries just as I would in access in order, for example, to pull all of my x-c time where dual time is greater than 0 to get the x-c dual time?
Or another example would be to show all x-c time where dual equals 0 to get x-c solo time.

Any help would be appreciated. Thank you.

Hello Jared,

You can do this for the most part using the Analyzer. Set the Master Filter to X-C and then you'll have all your time breakdowns for flights with X-C > 0. You could then subtract those values from the Totals without a filter applied to get the inverse, as required. Click here to read an article on this.
Thanks for the info. This is exactly what I needed! I actually found a few entry mistakes in the logbook after realizing the numbers weren't adding up correctly. Thanks again.