Need to update with data from next record
Need to update with data from next record
(OP)
Dataset looks like this:
I need the first order only, plus the order date of the next order, and discard the other records:
I've been all over with this, but can't quite get it. Any help is greatly appreciated.
CODE
Account OrderDate 100 5/1/2020 100 5/5/2020 100 6/1/2020 200 6/1/2020 200 6/2/2020 200 6/7/2020
I need the first order only, plus the order date of the next order, and discard the other records:
CODE
Account OrderDate NextOrderDate 100 5/1/2020 5/5/2020 200 6/1/2020 6/2/2020
I've been all over with this, but can't quite get it. Any help is greatly appreciated.
RE: Need to update with data from next record
CODE
Borislav Borissov
VFP9 SP2, SQL Server
RE: Need to update with data from next record
CODE
This gives 6/1 as the next order for account 100, and 6/7 as the next order for account 200. This is ignoring the second order for each account, which is the order date that I need. Thanks.
RE: Need to update with data from next record
CODE
Regards
Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Need to update with data from next record
How you know which record is first and which is Next?
Borislav Borissov
VFP9 SP2, SQL Server
RE: Need to update with data from next record
CODE
Bye, Olaf.
Olaf Doschke Software Engineering
https://www.doschke.name
RE: Need to update with data from next record