Good day
I have a table called Budget Accounts. Its entry has a start date, an end date, and a total amount.
Assuming that today is between the start date and end date, I would like to have a query that divides the total amount by the number of days (or weeks or months, doesn't matter for now), and then adds up the amount from the start date to the end date.
I can sort of do this if every single item had the same amount, but of course they don't!
Any suggestions are appreciated!
Thank you
Kavy
I have a table called Budget Accounts. Its entry has a start date, an end date, and a total amount.
Assuming that today is between the start date and end date, I would like to have a query that divides the total amount by the number of days (or weeks or months, doesn't matter for now), and then adds up the amount from the start date to the end date.
I can sort of do this if every single item had the same amount, but of course they don't!
Any suggestions are appreciated!
Thank you
Kavy
