Hi All,
I have a feild that holds the city and the state and I want to get rid of the last word in the feild.
Trouble is some feilds have 4 words whilst others only have 2.
What calculation can I use to just get rid of only the last word in every circumstance?

Thanks in advance

Milton.

LeftWords ( YourField ; WordCount ( YourField ) -1 )

Thanks John,

Works a treat.

On another matter, If I move up to FM PRO 11 Advanced, what benefits do I get when I make a standalone program?
Does the end user need FM?
Can my program be used on a server?
Can it be edited via remote desktop?

Regards

Milton.

Hi Milton,

The runtimes that can be generated with FileMaker Advanced have networking disabled (as well as PDF generation). So while the end user does not need FMP Client, they can't connect to served files or share data. Not sure what remote desktop would have to do with it.

As you can tell, runtimes aren't my favorite, nor my speciality. Sry.

Best,

John

Thanks John,
Very helpful.
If my program is used by 5 people they each need a copy of FMP 11, but do they need 5 copies of FMP 11 server, or just 1 copy?

Very confusing

Thanks for all the great help and advice

Milton

They each need a copy of FM11 and (possibly) one copy of server, though one of the FM11 copies can "host" the files, acting as a server. We recommend using server, however, even for 5 clients. More here:

http://www.filemaker.com/products/filem ... aring.html