I've spent the last 4 hours searching Google for an answer and can't seem to locate any advice that works for me so here goes:
Ok, first allow me to tell you what I'm doing. I am setting up a database to track Pilot Statistics and Awards for a group of gamers that play IL-2, a WW2 combat flight sim game.
I have established 2 tables:
Mission Results (where the results of individual missions are stored)I have a Querry called Pilot Points Earned that calculates the following values for each pilot:
Thank you in advance for any help you can provide.
Ok, first allow me to tell you what I'm doing. I am setting up a database to track Pilot Statistics and Awards for a group of gamers that play IL-2, a WW2 combat flight sim game.
I have established 2 tables:
Mission Results (where the results of individual missions are stored)
This has the following Fields:
British Military Orders (where the requirements for the awards are stored)Pilot Name
Mission Date
Ariel Victories
Kills Witnessed
Points Earned
Mission Date
Ariel Victories
Kills Witnessed
Points Earned
This has the following Fields:
Order
Order Rank
Order Letters
Points Required
Witnesses Required
Minimum Missions Flown
Order Rank
Order Letters
Points Required
Witnesses Required
Minimum Missions Flown
Total Missions Flown
Total Ariel Victories
Total Kills Witnessed
Total Points Earned
I need a way to compare the values for each pilot in Total Missions Flown, Total Kills Witnessed, and Total Points Earned against the values in the table for British Military Orders to see who has met the minimum requirements for which awards (whether it returns all the awards a pilot qualifies for or just the highest award a pilot qualifies for is all the same to me)Total Ariel Victories
Total Kills Witnessed
Total Points Earned
Thank you in advance for any help you can provide.