Search results

Hey that solved it! Yaay! the problem was I didnt press the sigma button(totals) in access. Thanks a lot! And to everyone else here as well :)

i tried this in expression builder to find the total tuition fee of each student SUM([UNITS]![Credit Points]*[UNITS]![Credit Point Fee]) but ACCESS gives me the error "you tried to execute a query that does not include the specified expression "StudentID" as part of an aggregate function"...

I've been stuck on this for hours! There are 3 tables in the database Students, Units, and Enrolment Student table Unit Table Enrolment table I need to use "expressions builder" to write a query to: Show the total tuition fee for each Student enrolled (credit points * credit...