Hi people,
I need to create a query to generate a table that brings data from the next record into the current record.
Example:
FIELD1,FIELD2,FIELD3
A1234,0,0
Null,Null,INFO
I need to produce a table that brings the INFO into the previous record. Ie,
A1234,0,INFO
Any help would be appreciated.