Computer Learning Zone CLZ Access Excel Word Windows

Learning is a treasure that will follow its owner everywhere.

-Chinese Proverb
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Access >
Back to TechHelp    Comments List
Dues Form issue Upload Images   Link   Email  
William Kennedy       
17 months ago
I'm updating my Lodges Treasurers database and trying to make the Invoicing portion easier to do.  A number of requirements make the process a little difficult to do in a database.  The Members Table, "Mem_125_Member_T" holds the basic information of all present and past members.  It is linked to a small table that keeps the status of members dues payments to the lodge.  Periodically the dues change as the member changes his circumstances.  Some members can pay his dues in one payment.  Other members need to pay over multiple periods.  Some even overpay in one fiscal year period and need to have it carried overed to the next Fiscal year. Some can not completely pay during the Fiscal Year and pay over multiple Fiscal periods for that period.
There is a helper table Mem_125_MemberDuesType_HT that is easily updated when required as MemberType status changes and Grand Lodge changes the Base DuesAmount.  I have been looking for the video Richard did on Combo fields that load the two values in the helper table into different fields in a table.  Cant seem to find it.  Can you point me to it?
One problem is that for the helper table easily give me the present Fiscal year dues requirements.  Need to keep accurate data over multiple Fiscal periods for an individual period.  I need a form and table that focuses on the Fiscal Period but can have payment dates can be over multiple entries but shows each payment amount, date and remaining balance for that fiscal year period.  The more automated the better. It would be very helpful that when the balance indicated zero or over payment that the Current Y/N field would be set automatically.  If I use the Debit Field as the stating value for that fiscal year dues. How do I carry over the previous balance into the next payment period if needed and only do that for the fiscal Period?
The report I think is not difficult.  Just a report Grouped by Fiscal Year, then Member that shows each payment and remaining balance, Current status and comments.  
William Kennedy       
17 months ago

William Kennedy       
17 months ago

William Kennedy       
17 months ago

William Kennedy       
17 months ago

William Kennedy       
17 months ago

William Kennedy       
17 months ago

William Kennedy       
17 months ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in TechHelp.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/23/2024 1:56:30 AM. PLT: 1s