Simple Title concatenation task

[Wickerman]

I'm still a calculation newbie, so this simple situation is puzzling me. I have a database of films, and since sometimes I'll want to print the simple title "The Big Sleep" and other times the 'postponed' version "Big Sleep, The", I have created two title fields: Title_Prefix and Title_Primary so that these elements can be manipulated in different situations.

Also, I have a radio button to click if the title is a "Given" title (one created by the cataloger in the absence of an official title). In this case, the copnvention is to enclose the title in brackets when printed: [bogart Test Film]. I call this third field Title_Given.

So, say I wish to create labels that include the simple title, and include brackets if that title is 'given'. I figure I create a new field, Title_Full defined as a calculation employing Let / Case / Evaluate functions like so:

Let ( [

_Ttext = Case ( IsEmpty ( Title_Prefix ) ; Title_Primary ; Title_Prefix & " " & Title_Primary ) ;

_Tprint = Case (IsEmpty (Title_Given) ; _Ttext ; "[" & _Ttext & "]" )

] ;

Evaluate (_Tprint) )

This seems pretty simple to me, and like it should work, but it doesn't. I've set the calc result to text, unstored. back in browse mode, I find my new field just has a ? in it - - - except, oddly, if the Title_Primary field has an entry enclosed in quotation marks, in which case it returns just this title (without quotation marks).

What am I doing wrong here?

Thanks!

Albert

[comment]

Your final result should be simply _Tprint, not Evaluate (_Tprint) ). Read the help on the Evaluate() function to see what it does.

[Wickerman]

Ah -- I see I was confusing two things I'd recently read about. Thanks for the nudge, Carpal!

Albert :(