Hi,

I have a x rows of 5 fields (name and home addresses)

The first 2 fields must have data.

How would I check if the first 2 fields have data and if not check
fields 3,4 and 5 for data and if exits move them to the fields 1 or 2.

Also if fields 1 and 2 have data and field 3 is empty move field 4 or
5 to field 3.

Hope that makes sense...

Thanks,

Ed