If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help on my simple DB design...
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! |
#2
|
|||
|
|||
dprocket wrote:
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. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I customise an entire design set | David | Publisher | 2 | November 12th, 2004 09:43 AM |
Table design & VB | AHopper | Database Design | 2 | November 10th, 2004 10:54 PM |
How to handle a change of design | Michael Wong | Database Design | 6 | May 23rd, 2004 02:57 AM |
Good Design Tutorials | DDM | Database Design | 0 | April 24th, 2004 05:19 PM |