By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

fund raising problem

P: n/a
I don't know if this is possible or not. A non-profit client is running a
fund raising campaign where a person can make a pledge that can cover from 1
to 5 years and can be paid in monthly, quarterly or annual installments.
Most of the database work is pretty standard except for one part. The client
would like to send out notices to each donor when the next payment is due.
With each donor having from 1 to 20 payments, and 1 to 12 payments per year,
and a start date that can be any date, there are a lot of variables to
factor in on the fly. Any ideas out there?

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Each payment should be a separate row in a table. Query that table to select
all payments due in the next n days.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"news.bellatlantic.net" <ma*************@verizon.net> wrote in message
news:pK*******************@nwrdny01.gnilink.net...
I don't know if this is possible or not. A non-profit client is running a
fund raising campaign where a person can make a pledge that can cover from 1 to 5 years and can be paid in monthly, quarterly or annual installments.
Most of the database work is pretty standard except for one part. The client would like to send out notices to each donor when the next payment is due.
With each donor having from 1 to 20 payments, and 1 to 12 payments per year, and a start date that can be any date, there are a lot of variables to
factor in on the fly. Any ideas out there?

Thanks in advance.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.