i need to write a calculated query

  • Thread starter Thread starter mmcsedward
  • Start date Start date
M

mmcsedward

i have to write a calculated query to show last name, first name, classes
taken, fees for classes taken(coursecost). I am pulling the information from
three tables, I am having a problem writing the expression to count the
number of classes each student is register for, and then find the fee for
each class and add this up and display the result
 
i have to write a calculated query to show last name, first name, classes
taken, fees for classes taken(coursecost). I am pulling the information from
three tables, I am having a problem writing the expression to count the
number of classes each student is register for, and then find the fee for
each class and add this up and display the result
Click to expand...

Care to post some information about the structure and relationship of your
tables? We can't see them from here.

Note that if this is homework for a course, getting an answer that works but
that you just blindly copy will NOT help you learn Access.
 
Back
Top