expressions in form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Topher - 23 May 2007 20:15 GMT

My boss wants me to build a database for people who donate money to us (which
I've never used Access until now). He wants me to set it by months, the
donation, the date the donation was given, nad the total year to date. On the
form we're using, he wants it where after the donation has been put in that
it will add the donation to the year to date and then equal the year to date.
At the office here they used to use Q & A and they said that program did it,
so Access should. Could anyone help me with this? Am I even headed in the
right direction? Thanks so much.

Reply to this Message

Klatuu - 23 May 2007 21:34 GMT

Yes, you can do it, but if this is your first time, you will have some
difficulty. You may want to see if there is a sample database that does that.
Open Access, click on help and look for sample databases. You will find an
entry "Sample Access Databases that you can download and adapt"

I would start there. If there is not one specific for that, download a
contact management database and you can add the donation tracking to that.

Having some examples to work from will help.

Your boss may be optimistic. Unless you are familiar with Access or at
least have an understanding of relational database design, it will be a
struggle. However, keep asking questions on these sites and I am sure you
will get through it.

Signature

Dave Hargis, Microsoft Access MVP

> My boss wants me to build a database for people who donate money to us (which
> I've never used Access until now). He wants me to set it by months, the
[quoted text clipped - 4 lines]
> so Access should. Could anyone help me with this? Am I even headed in the
> right direction? Thanks so much.

Reply to this Message