BBK
Registered User.
- Local time
- Today, 00:23
- Joined
- Jul 19, 2010
- Messages
- 71
I want to add a textbox field to my Lease table that will contain the date that each tenant would like to pay their rent, so that each day I would be able to run a query to check who owes rent for that day.
EG: The textbox field will only contain a single number beteeen 1 and 31, eg: 15 (so this would mean the tenant would pay his rent on the 15th of every month)
I then can check my bank statements and enter the payment for these tenants for that particular date and update their payment record. Now I would like to be able check who has not paid for this date by using another query.
How do I go about doing this, and how to avoid Saturday and Sunday results, cause there would be no payments on these two days.
Im completly lost on this one (as usual), and any help, advice or assistance is greatly appreciated.
Thank you
I attached the DB if it makes it any easier to give advice to a novice like myself. Thank you once again.
EG: The textbox field will only contain a single number beteeen 1 and 31, eg: 15 (so this would mean the tenant would pay his rent on the 15th of every month)
I then can check my bank statements and enter the payment for these tenants for that particular date and update their payment record. Now I would like to be able check who has not paid for this date by using another query.
How do I go about doing this, and how to avoid Saturday and Sunday results, cause there would be no payments on these two days.
Im completly lost on this one (as usual), and any help, advice or assistance is greatly appreciated.
Thank you
I attached the DB if it makes it any easier to give advice to a novice like myself. Thank you once again.
Attachments
Last edited: