Payment Diary Calendar

[EndersG]

I have a list of customers who receive periodic payments (either monthly, quarterly, semi-annually or annually). Each customer has an initial payment date (IPD) which I maintain on an MS Access table. From this list I want to create a query or form that will indicate what the next 12 payments will be utilizing the IPD as a reference/starting point. For example, a customer with an IPD on 10/6/99 electing to receive monthly payments would have future payments (FPs) from 11/6/99, 12/6/99, 1/6/00, etc. until 10/6/00. Another customer with an IPD of 3/22/00 choosing to receive quarterly payments would have 12 FPs of 6/22/00, 9/22/00, 12/22/00 all the way through 3/22/03. Someone with an IPD of 7/4/00 on an annual mode would receive FPs through 7/4/12. Get the picture? If possible, I'd like to list (on a form, report or query) those customers whose payments become due today, i.e. FP = Date(Now()). Maybe in a splashscreen at startup so I know which ones need to be handled that day.