All at once billing process.....

[drblackard]

I have created a form with lifetime membership and annually membership, these are check boxes ... when the check boxes are true, another box appears to record payment information....I also have the amounts paid (Which are different for each person)...now, how can I update all of these amounts with one command or update them annually in one process...This would be All at once update at the end of the year....thanks

 

[SkipVought]

Hi,

Seems as if you ought to have a table that has the annual dues requried for each person and then another table of dues received for each person with a date received and amount.

Nothing has to be updated annually, just when they pay.

Run a simple query to determine who needs to pay.

Skip,

_[red][/red]