pulling info from multiple tables or queries

[Guest]

I have created a donor database in Microsoft Access for the non-profit
organization i work for to maintain information on individuals and businesses
who donate and/or participate in our fundraising events. So i have a main
table of donor records, then tables for each of the fundraising events
individually, but they are all linked to the donor record table. I am trying
to create a query and/or form/ report that will give me the history of giving
for each donor.
For example:
John Smith 2005
GOlf tournament - golfer
Annual campaign - $100

Does anyone have any idea on how i would do this? When i create a query with
all of the fields, it runs blank.

Thank you!!

 

[Bob M via AccessMonster.com]

I have created a donor database in Microsoft Access for the non-profit
organization i work for to maintain information on individuals and businesses
who donate and/or participate in our fundraising events. So i have a main
table of donor records, then tables for each of the fundraising events
individually, but they are all linked to the donor record table. I am trying
to create a query and/or form/ report that will give me the history of giving
for each donor.
For example:
John Smith 2005
GOlf tournament - golfer
Annual campaign - $100

Does anyone have any idea on how i would do this? When i create a query with
all of the fields, it runs blank.

Thank you!!

My preference would be to have three data tables, one for donors, one for
event participation, and a
third table would be added with the information of each event (Name, Date,
type of event, etc.) I don't think creating a table for each event is such a
good idea - you get table clutter.
The donor table would have a unique Donor ID# for each individual and the
event information table would have a unique Event ID# for each event.
You would then enter your info, via a form, into the event participation
table with a lookup field that stores the Donor ID# in a field and the Event
ID# in another. That's all that has to be stored in that table. You can set
a form up based on the event information table where the Event ID# is
selected and then place a sub-form to enter the Donor ID#. They would be
linked on the Event ID#. This will insert the Event ID# in each record that
you enter a Donor ID#. This field in the sub-form can be a Combo Box based
on the donor table. You can lookup the name and have the Donor ID# placed in
the table.
I realize this is not what you asked, but as i said, I believe this is the
most efficient way to do it. It will save a lot of heartache in the long run.

By the way, your reports would be based on a query where all three tables are
queried.
If you have any specific questions about my solution, don't hesitate to ask.
Bob