Students Database: Upcoming Payment list queries help

[Bonolota1029]

HI, I have Students database, there are 3 times installment to payment fees. i want some of this function in my database but i dont know how..



1. I want to see Next 15 days Upcoming payments List with date and amount, also name and address.

2. Separated by which has been over from due date and upcoming date.

3. Remove from query table after payment has paid.


If you could give suggestion how do i can create this function in my database.

Thanks in advance..

[Bob Fitz]

Cross posted: https://access-programmers.co.uk/for...d.php?t=295353

Please read: https://www.excelguru.ca/content.php?184

[Bonolota1029]

Cross posted: https://access-programmers.co.uk/for...d.php?t=295353

Please read: https://www.excelguru.ca/content.php?184

I have posted this with two web site for having quick answers..

[Bob Fitz]

I have posted this with two web site for having quick answers..

Have you read the link that I posted

[andy49]

Look up datediff function for a start. You can run a query which lists the info you need where datediff(date(),paymentduedate)<=15

[Bonolota1029]

Look up datediff function for a start. You can run a query which lists the info you need where datediff(date(),paymentduedate)<=15

Thanks for reply.
but i am not sure how to do it. will you please guide me step by step how can i do it?

[orange]

Bonolota1029,

When you cross post, tell readers that you have done so, and
include a link(s) to the other post(s).

You say you want to add a function to your database, please provide a description of your database-especially the tables you have.