Database query

[Nifty]

I have had issues with Java but think I have fixed. I am out of my depth in respect to queries. I have two databases one cadets and the second scores. If they score 65% they get one badge and if they score 85% or better they get another badge.

These badges are for the life they are in cadets. However they might shoot many times over the 5 years. I have to report monthly those recipients earning either the 65% or 85% badge. However I don't want to repeat those that have all ready received the badge.

Can somebody help please.

Many thanks
Nev