Get data from next record

[andydawson]

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,F IELD3
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.

[FishVal]

Hi, Andy.

A very obvious question.
How would a record be recognized as a next to a given one?

Regards,
Fish

[lee123]

maybe try defaulting this that's the only way i can see unless your psychic

lee123