Kayleigh
Member
- Local time
- Today, 15:23
- Joined
- Sep 24, 2020
- Messages
- 706
Hi
I'm sure there's a quick answer to this but cant find a suitable solution.
I'm looking to automatically append records to a table which stores transactions - some staff have standing orders set up weekly. I would like this recorded in the database automatically. I have the weekly amount stored and can also store day of week although i think it can be calculated?
So how would I design the query?
Kayleigh
I'm sure there's a quick answer to this but cant find a suitable solution.
I'm looking to automatically append records to a table which stores transactions - some staff have standing orders set up weekly. I would like this recorded in the database automatically. I have the weekly amount stored and can also store day of week although i think it can be calculated?
So how would I design the query?
Kayleigh