AaronKempf.com | CareerDBA.com | FullStackWP.comunread,
Jan 11, 2021, 5:44:02 AM1/11/21
there are a hundred ways to do it. but you'll need to give a lot more details. Table names would be a good place to start.
but from what you're looking at, I'm gonna guess that you'll be wanting to use Triggers or Stored Procedures to do this. Iterating through to the 'last row' or even the 'next row' aren't really as powerful in Access as they are in SQL Server.
I can help, but it's gonna be slow to get you up to speed. Hit me up!~