Hello guys
I have a problem with creating a specific query.
You have three tables: one for student information including name, class (ranging from 1 to 5), and nationality (either your a national or a foreigner). The second table shows the tuition fees and registration fee for nationals across the five classes, and the third table does the same for foreigners.
I would like someone to help me on how I can go about with this on accesss, so as to retrieve the appropriate fee information based on a student’s nationality and class, whether they are a national or a foreigner. So, if you input “national class 3,” Access should display the fee for a national student in class 3, including registration and fee. Similarly, if you input “foreigner class 4,” Access should show the fees for a foreign student in class 4. Thanks for the help in advance
I have a problem with creating a specific query.You have three tables: one for student information including name, class (ranging from 1 to 5), and nationality (either your a national or a foreigner). The second table shows the tuition fees and registration fee for nationals across the five classes, and the third table does the same for foreigners.I would like someone to help me on how I can go about with this on accesss, so as to retrieve the appropriate fee information based on a student’s nationality and class, whether they are a national or a foreigner. So, if you input “national class 3,” Access should display the fee for a national student in class 3, including registration and fee. Similarly, if you input “foreigner class 4,” Access should show the fees for a foreign student in class 4. Thanks for the help in advance Read More