Hey everyone. Im new here and i am really at my wit's end on how to make a query my assignment instructs. I am done flipping through the textbook and finsing the how -to-do tips in the net but i still have no idea how to do this.



OKay here goes, my database is a database for a health gym and has 3 branches for location. And for members, we have two types of memberships.

Right now, key information that is given is that, ordinary members (one of the members ) are entitled to a 10 percent discount for each class they sign up

Ordinary members are those who have signed up for 2 year subscription and by contrast with associate members, they pay on monthly basis.

Now the question is how do you create a parameter query to list all the classes signed up by each member and fees payable after discount? I am stuck here and i think ive pulled enough hair along the way.