How to combine text from 2 different fields.

[J]

I am sure this is a stupid question, but how do I combine 2 text fields. I am used to lotus approach.

Current Field value="test"

Need field value to="test2"

Thanks.

FileMaker Version: Server 7

Platform: Windows 2000

[Lee Smith]

Hi Jason,

I'm not sure what your field names are or what the contents of your field really are, but in order to have a calculation combine two fields that have the result of text, you would use the & sign. (Test Test2)

TotalField = (calculation, Text Result) =

Field 1 & Field 2

and if you need to separate the text

Field 1 & " " & Field 2

If the contents are numbers and you want to add them (2+2 for a result of 4)

TotalField = (Calculation, Number Result) =

Field 1 + Field 2

HTH Lee

Note to Steven

I tried to post this and needed to edit the post. The result of that edit made the whole post unreadable. I wish that we could fix this so when we edit a post, it doesn't put everthing into one paragraph.

[J]

Thank you.

I new it was a stupid question. Great Answer.

Jason

[Lee Smith]

Hi Jason,

There are NO stupid questions. How else do we learn what we do not know..

You are welcome.

Lee