[Peter]

Im newly working at the NZ affiliate of an international charitable
organisation. The database currently used is fairly old and some fields were
never perfectly consistent with our local situation. So over the years data
entry has been inconsistent. Medium term goal is a new international
database and cleansed data, but in the meantime I would appreciate coding
ideas for a specific scenario.

For addresses in all correspondence the field layout should include:

Suburb (if not null)
City Postcode

Where Suburb and City both have values, the data entry is consistent.
But where Suburb is blank (eg for a small rural town) the City value may
have been typed into the Suburb or City field. In such a case the
alternate field will then be null.

So I need a set of conditional field merges that cover (I think) three
possibilities:

Suburb
City Postcode

or
City Postcode (if Suburb is Null)

or
Suburb Postcode (if City is Null)

I can do bits of this but am having trouble with the layout needing to be on
one or two lines. I presume I need to insert a line break or equivalent but
dont know how to code this.

Thanks in advance for any help.

Peter.