Joining fields if Empty

[markf]

field 1 record 1 is empty, field 2 record 1 has data

field 1 record 2 has data, field 2 record 2 has data

How do I move the data from field 2 into field one only if field 1 is empty?

Any help would be most welcome!

(I am just learning)

Thanks

Mark..

[Thanh]

Try this

Go to Record/Request/Page [First]

Loop

If [field1 = ""]

Set Field [field1; field2]

End If

Go to Record/Request/Page [Next; Exit after last]

End Loop

[markf]

Thanks for that it works well and has sorted out my

problem.

I am learning slowly but surely!

Cheers

Mark..