If you have tblPayments as I suggested, summarizing payments by enrollmentID or StudentID or ClassID should be simple. That's what reports are for.
VIP
Windows 7 64bit 
Access 2010 32bit
If you have tblPayments as I suggested, summarizing payments by enrollmentID or StudentID or ClassID should be simple. That's what reports are for.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Need To Sum Payments in Query
Posting Permissions
Reply With Quote