[mso] Getting Access to do the math for me
- From: "Katherine Driskell Felts" <subscriptions@xxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 7 Jun 2004 10:39:04 -0500
Hello friends. I about have the data base merging I told you about
done. What I did was exported tables into Excel, cut and past info into
the appropriate columns and then imported it back into Access. It would
have been nice if I could have cut and pasted directly into Access, but
I never figured that out.
Here's the current problem: Now that I have the 02 and 03 donations in
with my 04 ones, I'd like to have a field on my main donor page (with
contact info and such) that tracks the total giving by year and total
giving history. Then I want to be able to ask the data base who my
LYBUNTS are (Last Year But Unfortunately Not This Year) donors are
(they're good prospects). I'll also, in the future want to be able to
write a letter to my donors and suggest donations that start at last
year's giving + 5% rounded up to something reasonable, and then with
giving options that go up from there. Can someone tell me where to find
the easy obvious way of doing that?
Thanks,
Kathie
P.S. a good book recommendation would still be appreciated.
Katherine Driskell Felts,
Executive Director
Blooming Prairie Center
Deep Roots, Bright Futures, Unlimited Horizons
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] Getting Access to do the math for me
