Students Database: Upcoming Payment list queries help (1 Viewer)

HI, I have Students database, there are 3 times installment to payment fees. i want some of this function in my database but i don't 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..

Cross posted: http://www.accessforums.net/showthread.php?t=67633

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

Please provide sample data demonstrating what your data is in your tables and what you expect the queries to return. That means at least 2 sets of data:

A. STarting data from tables. Include table and field names and enough sample data to demonstrate all cases.


B. Expected results of A. Show what you expect to end up with when you feed your queries the data from A.