Include expressions in table

[siedne]

Hi



I am helping my professor neaten her student database. The database includes no. of credits and grade points for each class. I was wondering if access could calculate a student's total credits and total grade points, and consequently GPA.

Is this possible through a table? Do I have to create a query instead? If so, how do I make the query smart enough to detect new entries and calcutate total credits, total grade points and GPA without having to run the query each time we add a new student?

Hope this makes sense.

[boblarson]

You have to create a query. And you don't store calculated values in the table. You just run a select query when you want to view the data instead of opening the table (which is actually just a system query anyway).

[siedne]

Ah I see. Thanks for clearing this up!