Rupesh Singh
New Member
- Joined
- Dec 10, 2019
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi,
I have a table in MS access, I want to assign Starting value of next duplicate Name's data as Remaining value of previous row. And default (1000000) to first Remaining value based on the Name column. Please find the attachment for more details.
Please suggest any query or VBA code to find the same
Thanks
I have a table in MS access, I want to assign Starting value of next duplicate Name's data as Remaining value of previous row. And default (1000000) to first Remaining value based on the Name column. Please find the attachment for more details.
Please suggest any query or VBA code to find the same
Thanks