Bill all members at once....

[drblackard]

I have created a database for my softball team and the year has ended...I was wondering how I could create a process to bill all the players (which are different charges) by using a query or a command button referring to this command to update at the end of each year. Please give details when submitting so I get it into use quickly....

 

[PHV]

Please give details when submitting so I get it into use quickly
Are you trying to use this site as a help desk, don't you ?

what have you tried so far ?
Where are you stuck ?

Please read CAREFULLY either FAQ in my sig !

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[drblackard]

I have seached and found one other forum about Membership All at ONce update...but it never finished explaining how to do this procedure...It said use a query to update each year which is kinda like what I need but did not give instructions or steps to create it...I am pretty good with MSAccess (which is what I am using by the way, sorry for not stating this earlier) and have created a pretty good database but I am looking for that one last thing to complete it and did not think about this feature until years end...here it is...I need to update so I will know who coming back and record their payments already made.. Thanks for you help....as far as tried, I have not tried anything because I did not know how to build such a query to update ALL members...sorry

 

[drblackard]

Someone please help me...thanks...

 

[randy700]

Sorry, but this site is not here to do the work for you. If you attempt to create the queries, functions, etc and run into trouble, we will try to get you pointed in the right direction. However, statements such as...

I have not tried anything

...will NOT get the work done for you. You MUST make an honest attempt to build your own procedures.


Randy

 

[drblackard]

I don't know where to start or how to design such a feature...point me in the direction...I have not built something like this before and was wondering if anyone had insite but it seems instead of helping, people assume you are not trying...I am trying, I just don't know what/how to start this type of process..Thanks for your input randy700

 

[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...This would be All at once update at the end of the year....thanks