Membership Database, Point/Level System Help

[DRAGONFABLE517]

Hi i am a bit fresh with MS Access, i know most basic stuff, but I need help, I am creating a rewards/membership Database/system for a yr 12 project. I am stuck at how I am going to make it so that once the member has a certain amount of points they will increase their membership level, hence enabling better rewards. all members start at the beginning level (i.e lvl1).



As an example reference to what i am talking about is EBGames Rewards Program, which can be found here <link removed by moderator as spam prevention>

[June7]

You can either modify the member's record or write code that will dynamically calculate member level when needed.