Three fields into one

[Develop]

I'm trying to get records from three different fields to display under ONE column on a report.

For example, I have three different job titles (PD, AR, ED) which I would like to display under a fourth title, Contact.

Does anyone have any suggestions on how to do this?

Thanks.

[Genx]

Assuming that I understand what you're talking about, you have two options:

Option 1 = Create a new calculation field result = Field1 & " " & Field2 & " " & Field3

Option 2, use merge fields:

Enter Layout Mode for your report, click once under your column, press ctrl M, choose Field1, don't exit the label, press ctrl M again, choose Field2, press ctrl+M again choose Field3: Should end up with something like:

<> <> <>

[Vaughan]

Read up on FMP's calculation fields, and specifically about concatenating text fields. (Hint: the ampersand is your friend.)

Just don't ask how to pronounciate "concatenating". ;-)

[Genx]

Just don't ask how to pronounciate "concatenating". ;-)

LOL!

[comment]

What is "pronounciate"?

[Søren Dyhr]

LOL! like proverbiate?? ...proadverbiate??

--sd

[Genx]

Lol:

http://www.urbandictionary.com/define.php?term=pronounciate

[comment]

Check a REAL dictionary, will you?

[Genx]

Lol, but that one got 8 thumbs up vs 7 thumbs down!!!

Joking joking, but for some reason it reminds me a bit of my fair lady: "Well if I was doing it proper, what was you sniggering at? Have I said anything I oughtn't?"

... That or one of George Bush's speaches

"That's why we are inconveniencing air traffickers, to make sure nobody is carrying weapons on airplanes."

Edited June 4, 2007 by Guest