I'm building a database for work. I've got a good start, but I'm having trouble with part of it. This is what they want:
Also - is it even possible to have 4 different pend times (15/30/45/60) and have them all show up in the same place (query/form) when their time is up?
Any ideas on how best to approach this scenario? Any help would be appreciated! Thank you!
- Import a spreadsheet of accounts with missing documents (done)
- User will view the record and see if they have received the documents
- If yes, complete from database
- If no, fill out some fields (name/address/what is needed, etc.), create and send a letter to customer.
- User will mark the record as pended for 15/30/45/60 days, depending on situation, and add notes. Date/userID auto fill.
- Have a "Pending Queue" where anything that is due to be looked at again will appear
- Repeat - look for documents. If not received, send another letter and pend again
- Complete from database and remove from pending queue once docs received.
Also - is it even possible to have 4 different pend times (15/30/45/60) and have them all show up in the same place (query/form) when their time is up?
Any ideas on how best to approach this scenario? Any help would be appreciated! Thank you!
Last edited: