I have two tables. One table has children names, grade, and child number. Table two is a tuition chart that lists tuition by Grade and then has columns for Child number. I need a query that will return the child's name and his tuition based on his grade and child number. I have enclosed two excel files showing the tables. I would like to do this by just using queries if possible.
Thanks for the help.