I'm completely new to Crystal, using version 8.5.

I have two name fields, one for individuals and one for companies. I want to merge them into one (no record has data in both fields). I thought I'd be able to do that with concatenate, but it's still only giving me the data from one field. Is there a different formula I should be using?

Thanks!

i've never used crystal, but i believe it uses SQL, right?

try the COALESCE function, which returns the first non-null parameter value reading from left to right

so COALESCE(field1,field2) will return field1 if field1 is not null, and field2 if field1 is null

and if both are null, then of course it returns null, unless you add a default value as a 3rd parameter --

COALESCE(field1,field2,'booyah')

I suggest upgrading to latest crystal version, then buy a reference book. I had to when I started out. on 8.5 back in 2005. you can use the text object icon and put fields in it. not sure if that is what you want. Also I am on here once in a blue moon. so reply back to me is mute. Yes, SQL is used by the program but the program write the sql (similar to access) for you as long as you know how to do proper ER diagram builds.