Please help on my simple DB design...

[Guest]

Ok, i've banging my head against the wall on a seemingly simple issue. I am
not a DB guy and I do no programming (not SQL stuff for me) so I am at the
mercy of the Access wizards and built in helps.

I handle the weekly donations for my church. I have two major tables. On
table has a list of "Contacts" which contains names, contact info, mailing
addesses, etc. This table has a primary key which is an autonumber for each
contact. I also have another table that is the "Contributions" table. This
table basically is a break down of what each contact has given each week
(cash amounts, check amounts, etc.). It also has a primary key which is a
autonumber and I have a one-to-many relationship set up with the ID of the
Contacts table and the "name" on the Contributions table.

Each contact could theoretically have many entries in my Contributions
table. What I'm trying to do doesn't seem like rocket science. I want to
creat a report that shows a nice looking output for all the contributions for
a given account. Again, it doesn't seem like rocket science but I can't
figure out how to do this. Can someoen help me or point me to a tutorial
that will break this down for me? Thanks!

 

[Rick Brandt]

Ok, i've banging my head against the wall on a seemingly simple
issue. I am not a DB guy and I do no programming (not SQL stuff for
me) so I am at the mercy of the Access wizards and built in helps.

I handle the weekly donations for my church. I have two major
tables. On table has a list of "Contacts" which contains names,
contact info, mailing addesses, etc. This table has a primary key
which is an autonumber for each contact. I also have another table
that is the "Contributions" table. This table basically is a break
down of what each contact has given each week (cash amounts, check
amounts, etc.). It also has a primary key which is a autonumber and
I have a one-to-many relationship set up with the ID of the Contacts
table and the "name" on the Contributions table.

Each contact could theoretically have many entries in my Contributions
table. What I'm trying to do doesn't seem like rocket science. I
want to creat a report that shows a nice looking output for all the
contributions for a given account. Again, it doesn't seem like
rocket science but I can't figure out how to do this. Can someoen
help me or point me to a tutorial that will break this down for me?
Thanks!

Create a query joining the two tables together on the appropriate field and pull
down into the query grid the fields you want in your report.

In the Report create a Group Section on ContactID. In that section include
whatever fields you want about the Contact. In the detail section put the
fields that pertain to each contribution. If you like you can also have a Group
Footer on ContactID and put a control there to give a total for the Contact's
contributions by using a ControlSource of =Sum(Contribution).

The Report wizard should get you 95% of what is described above.