Recent content by farner

I'm using Access 2007. This is my setup: Tables: Students, Parents, Tuition, Payments, Faculty My database is for a school that involves Students, Faculty, Parents, Tuition, and Payments. What I have is the Students listed under their Parents (they register as families), and the Payments...

Alright, so I took care of the sum issue by using queries to calculate the sums and unbound controls in my report to perform the Total Tuition and Balance calculations. Those will show up each time I generate a report. Now what I'm trying to do is have the list of payments show up in the...

@plog Thank you for your reply. I understand the recalculation and accuracy bit, but the reason I want it in a table is that my DB isn't very formal and at times I just add records right in the table rather than use the form. I want to be able to see the calculation in the table with the...

I'm using Access 2007, and I want to calculate the sum of a field in one table and store that sum in another field in another table. I don't expect the original field to change much so I don't want to use a query just to calculate the sum and display it, I want to actually store it and display...