[mso] Access again--automated entry of date thank you notes were sent

  • From: "Katherine Driskell Felts" <subscriptions@xxxxxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Tue, 3 Aug 2004 11:18:27 -0500

Hey guys, I got a query to accurately produce the information I needed
to send thank you notes to donors.  Woo Hoo!  Two months of off and on
work pays off!  Here's my question now for the best and the brightest of
those who face Redmond when they pay homage to the gods of capitalism:
 
Is there a way to tell access to automatically keep track of the fact
that the thank you note was finally sent on August 2?  What would be
really great is if that would go in my donations table right next to the
date received and amount, and THEN the next time I go running a query,
if it would remember that the last set of thank you notes went out on
August 2, so it would automatically know to grab records with dates
between August 2 and the next time I run thank you notes (that date).
Now, it can't just notate that the query was run, cuz I might run it to
get information for a board member, it has to ask me if it should notate
it.
 
I can see why programmers like their jobs-its cool when it finally
works!
 
Kathie
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: