[mso] Re: Access again--automated entry of date thank you notes were sent :VSMail mx2
- From: "Katherine Driskell Felts" <subscriptions@xxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 3 Aug 2004 12:27:53 -0500
No!! It did work!! It turned out I hadn't set the format to short date
on the donations table!! Woo hoo! Okay, now is there an easy way to
link that donation to the thank you letter that was sent? It would be
AWESOME to be able to look at a donor's record and be able to link to
ALL correspondence I'd sent to them so when and if there is another
person sitting at this desk they have an understanding of the
relationships we've built with our supporters.
BTW, on another set of lists I'm on (charity issues) someone has asked
if they have coding they put in their databases that indicates that
Donor A can't stand Donor B. Ethics dictates that we don't put anything
in our files or databases that we wouldn't want the donor to look at,
but a good event requires that we know about these sorts of things and
not forget them. Made me smirk because I'm working on the database
today and that seems like a good field to put in there.
Kathie
Katherine Driskell Felts,
Executive Director
Blooming Prairie Center
Deep Roots, Bright Futures, Unlimited Horizons
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of James LaBorde
Sent: Tuesday, August 03, 2004 12:13 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access again--automated entry of date thank you notes
were sent :VSMail mx2
Kathy,
The problem you are having is that you are trying to multiply a date and
Access can't handle that. Try taking out the 1* portion of your
criteria
and you will take care of your problem. Your criteria should look like
this:
*************************************************************
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:
