Newbie with MAJOR HELP needed on this query

[ad.business]

I have a table with the following fields, month, name, and % to goal (sales).
I am trying to start a certification program for their sales. Anyone who gets at least 80% to goal for 6 months in a row will receive a title of "Intermediate" and will get a 10% increase for that months check. Anyone who is 100% to goal for 4 months in a row will receive a title of "Expert" and will get an extra 20% on that check. Anyone who get 100% to goal for 4 months in a row and has no tardies (tracked separately) will receive a title of "Expert II" and will get an extra 25% boost on their paycheck. They must progress through each of the tiers to receive the extra money on their paycheck, meaning, they must first meet the Intermediate criteria, then the Expert, then they will be eligible for the "Expert II" title. If they do not meet the criteria, they will start over again at their current level. So if they are in the "Intermediate" title running, and they pass 3 months, and their 4th month, they do not meet, they will have to build 4 months in a row to gain that title.



I need to have a database to track this information. How would my query look for this? What's throwing me off is being able to assign a title to them without having to manually figure this out. If they miss a month, I need to start the counter over again. Please help.

 

[VilaRestal]

It sounds quite involved. I think you might end up having to do it in VBA - looping through a recordset of a particular person's records and analysing their % each month. I wouldn't try to do it in a query (it's the missing a month zeroing it bit that would be very hard to do in a query)