Billing

G

Guadalupana

Using Access 2000 to do billing for a tiny water utility, I'd like to add a
monthly charge to accounts on the 10th day of the month, and to add a late
fee to accounts that haven't been settled by the last day of the month. Is
there a way to make this happen authomatically? I'm a self-taught person and
don't know the language.
 
L

Larry Linson

Using Access 2000 to do billing for
a tiny water utility, I'd like to add a
monthly charge to accounts on the
10th day of the month, and to add a
late fee to accounts that haven't been
settled by the last day of the month.
Is there a way to make this happen
authomatically? I'm a self-taught person
and don't know the language.
Click to expand...

What you want can certainly be done, but without knowing what information
you have and how you are storing it, that's about as specific as anyone can
be.

If you will describe the tables you have, and give us some details about the
rest of your database, then perhaps someone can make some useful
suggestions.

If you don't know any VBA, you may have to learn some, but there are lots of
people here in the newsgroup to help.

Larry Linson
Microsoft Access MVP
 
G

Guadalupana

Thanks, Larry ...

I have a table called "members" which has a list of the folks who are, or
have been, connected.
I have a table called "income" which has a list of receipts, connected with
the members via the "member ID."
I have a table called "correspondence" that has an entry every time I send
someone a letter (usually about delinquency) connected with members via the
"member ID."
I have a "members form" (that I've just screwed up, but I think I'll have it
again in a little bit) that displays the members' info, all receipts from
that member, and all correspondence with that member. I go to that form and
figure out what folks owe. I'd like maybe to have that figured out by Access
on the basis, perhaps, of the balance as of December 31, 2004 (when we
changed our rates), and the receipts we've gotten since them, as shown in the
"income" table.
Does this make any sense? Should I be telling you something different? Are
you a staff person or just a very NICE person? Thank you, anyhow,

Guadalupana
 
Top