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 *************************************************************