Forum Discussion
Create an installment due range for installment payments
Hi all, I am at my wits' end, trying to create a report on an estimate of income for six months, and Access, gives me $0.00. Please any suggestions.
My suggestion is that you provide much more detail.
Include in your response:
The categories and types of income involved.
The actual values being used in the estimate.
The algorithm you want to implement to create the estimate.
Include in your response:
The categories and types of income involved.
The actual values being used in the estimate.
The algorithm you want to implement to create the estimate.
George_Hepworth Thanks so much for your email.
We are an institute, so one of the fields in Access is the student ID, followed by Application fees, materials/resources, Initial Deposit and then a break-down of instalments with due dates to be paid, and then, dates that were paid. I used to be able to create a report which would show the estimate of all students from 01/06/2023 till 31/12/2023. I do what I used to do, and it gives, an estimate of $0.00. I really don't know what I'm doing wrong. Please help if you can. It would be greatly appreciated.
- Unfortunately, I can't "see" what you see. We only know what you include in these posts. So far we know that you somehow "break-down installments". That's not sufficient to be able to offer useful suggestions.
When I asked for actual values and algorithms, I meant things like the actual initial deposits for a number of students, for example, by dollar amount and date paid. Without that detail, it's impossible to guess what the errors might be. Best of all is a copy of the accdb with just enough data to illustrate what is needed. Remove Personally Identifiable Information, but provide realistic values.
Thank you.