Kayleigh
Member
- Local time
- Today, 23:04
- Joined
- Sep 24, 2020
- Messages
- 708
Hi
Can someone help me with creating an append query to create invoices once a month if child is registered. It will run when main screen opens but user may not open DB every day so how to i program it to check if last invoice was 30 days ago and create new record?
I would also like to do a similar solution on a weekly basis.
Maybe I'm thinking too much into the problem - may be a simple solution!
EDIT: Just did a quick Google and found this - https://bytes.com/topic/access/answ...end-update-queries-automatically-weekly-basis . Is it the most advisable option?
Part of DB is attached.
Many thanks
Can someone help me with creating an append query to create invoices once a month if child is registered. It will run when main screen opens but user may not open DB every day so how to i program it to check if last invoice was 30 days ago and create new record?
I would also like to do a similar solution on a weekly basis.
Maybe I'm thinking too much into the problem - may be a simple solution!
EDIT: Just did a quick Google and found this - https://bytes.com/topic/access/answ...end-update-queries-automatically-weekly-basis . Is it the most advisable option?
Part of DB is attached.
Many thanks