Hi,

I'm relatively new to access and Im using access 2003.  I created a
small database in an effort to track how much my friends owe me (just
as a learning experience).  I have two tables. 'Debts' and 'Debtors'
The primary key in 'debtors' is used in 'debts' as the refference.

In 'debts' I enter data in this format:

Debtor ID (Primary Key from 'debtors')
Reason
Date
Due
Amount
Paid (checkbox y/n)
On time (checkbox y/n)

In the 'debtor' database I want a field for each debtor called 'Total
Debt'. How can I add up all the 'Amount Due' Fields from the records
that match their primary key refference in 'debts'.

=====

Second

How do I exclude records from a report based on a checkbox? I.e. I
want to print a report of all that owe, therefore the 'paid' checkbox
would not be checked.  How can I exlcude records that it is checked
on?

====

Finally,

How can I generate a page of a report for each 'debtor' with each debt
line listed -- I made a 'master' report but im looking to make a
'debtor copy'

Thank you for any and all help!!