Vulpeccula
New member
- Local time
- Today, 10:58
- Joined
- Sep 5, 2020
- Messages
- 23
Hello to all you Access-Programmers,
I am appealing for help on a simple, two table credit card app: tblCreditCard and tblTransactions.
Associated forms are: frmCcList (unbound with list box lstProvider), and frmTransactions (unbound with listbox lstTransactions).
So, we double-click on a card provider and via qryTransactions, we populate lstTransactions – straightforward.
To the crux of the matter: - reports; I need to forecast the minimum payment required at statement date then predict the “payment due” date.
Problem: some providers require payment within 21 days of statement, others require payment within 28 days, for some it is PCM (per calendar month).
The challenge: I can work out a calculation for “payment due” based on the number of days interval as stated by each provider, but how do I calculate PCM ?
Any assistance would be gratefully received
Thanks in advance guys...
I am appealing for help on a simple, two table credit card app: tblCreditCard and tblTransactions.
Associated forms are: frmCcList (unbound with list box lstProvider), and frmTransactions (unbound with listbox lstTransactions).
So, we double-click on a card provider and via qryTransactions, we populate lstTransactions – straightforward.
To the crux of the matter: - reports; I need to forecast the minimum payment required at statement date then predict the “payment due” date.
Problem: some providers require payment within 21 days of statement, others require payment within 28 days, for some it is PCM (per calendar month).
The challenge: I can work out a calculation for “payment due” based on the number of days interval as stated by each provider, but how do I calculate PCM ?
Any assistance would be gratefully received
Thanks in advance guys...