[mso] Re: Access doing Math Part 2 :VSMail mx5

From: James LaBorde <jlaborde@xxxxxxxxx>
To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
Date: Tue, 3 Aug 2004 11:24:05 -0700
Kathie,

This would be another good thing you could put in a sub-form.  That way you
could make the subform read only and leave your main form as editable.  Your
best bet for your results would be a crosstab query.  Grouping by members,
sorting by year and summing amount.

James

-----Original Message-----
From: Katherine Driskell Felts [mailto:subscriptions@xxxxxxxxxxxxxxxxx]
Sent: Tuesday, August 03, 2004 11:20 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access doing Math Part 2 :VSMail mx5


Okay, James, I'm printing out an answer you sent me weeks ago about
doing queries to determine LYBUNTS and SYBUNTS.  Thank you.  I'm almost
up to speed to understand you.  I'm wondering, however, if I'll be able
to have this display on the main donor info page (and not be
changeable!)  So, on my page where I have their name and address, etc.
I also want it to have 02 giving, 03 giving, and 04 giving.  
 
Wouldn't it be cool if I could calculate how much increase or decrease
there'd been.  One day that'd be good to flag to follow-up.  Maybe we
offended them, maybe they're dead, maybe they don't have the capacity to
give at such high levels anymore.  
 
But that's off the subject, the question is just, can I get the results
of all these queries to display on the main form for data input (which,
not incidentally still has the tab order screwed up, there's an on entry
messing me up somewhere, which I can't find but has a maddening tendency
to remove folks last names and replace them with numbers).
 
Thanks again,
 
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
*************************************************************
*************************************************************
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
*************************************************************
[mso] Re: Access doing Math Part 2 :VSMail mx5

Other related posts:
