Track years

[bgibsonIYD]

I need to be able to track years for a campaign. Each person in my database is in the Fall 2000 campaign (what we are starting with). We will be getting new names for the Fall 2001 Campaign soon. Some of those names I will already have in the database, and some will be new names. I would like to track it in a way that we can tell who donated in the previous years. What would be the best way to do this.

I also need to purge the names that are not continuing the campaign into another table so we can mail to them later with seperate information.

Any help in these two matters would be appreciated!

Beth
**Learning Access**

 

[LarryDeLaruelle]

Beth:

You'll need two tables (at least).

The first will contain donor information; the second will contain donation information.

The second table should have donation date, donor ID (link back to donor table), donation amount, etc.

You can then query the donation table to who did or did not donate in any given year based on the donation date.

Hope that helps.
Larry De Laruelle
larry1de@yahoo.com

 

[THoey]

It sounds to me like you probably have one large table tracking everything. You probably want to split this up into a couple of tables:

tblDonor
DonorID
FirstName
LastName
SSN
...

tblDonation
DonationID
DonorID
DonationYear
Amount
...

Using a format like this will allow you to have different years, allow different reports to be easily created, cut down on redundant data, etc...

Hope that helps... Terry M. Hoey