http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/25473.aspxMon, 26 Jan 2015 18:31:36 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25473Method_Justin0http://forums.method.me/cs/forums/thread/25473.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25473<p><span id="mce_0_start" style="overflow:hidden;">Hi Marcelo,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Try&nbsp;<span id="mce_1_start" style="overflow:hidden;">putting the work order name in single quotations.</span></p> <p><span style="overflow:hidden;">I should also point out that the operator for &quot;equals&quot; is <strong>== </strong>(double equal&nbsp;sign).<span id="mce_5_start" style="overflow:hidden;"></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;">Hope this helps.</span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;">- Justin</span></span></p>http://forums.method.me/cs/forums/thread/25458.aspxSun, 25 Jan 2015 18:34:49 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25458Marcelo117560http://forums.method.me/cs/forums/thread/25458.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25458<p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_1_start" style="overflow:hidden;">I need help with the expression of a c<span id="mce_4_start" style="overflow:hidden;">a</span>lculated field in a report</span></span></p> <p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_1_start" style="overflow:hidden;"></span>I want the field to show <span id="mce_2_start" style="overflow:hidden;">&#39;</span>weekly&#39;<span id="mce_3_start" style="overflow:hidden;"> unless the name of the work order is <span id="mce_7_start" style="overflow:hidden;"></span><strong><span id="mce_9_start" style="overflow:hidden;"><span id="mce_10_start" style="overflow:hidden;"><span id="mce_11_start" style="overflow:hidden;"></span></span></span>Lawn Service<span id="mce_6_start" style="overflow:hidden;"> (25)<span id="mce_7_end" style="overflow:hidden;"><span id="mce_9_end" style="overflow:hidden;"><span id="mce_10_end" style="overflow:hidden;"><span id="mce_11_end" style="overflow:hidden;"><span id="mce_13_start" style="overflow:hidden;"> <span id="mce_14_start" style="overflow:hidden;"></span></span></span></span></span></span></span></strong><span id="mce_6_start" style="overflow:hidden;"><span id="mce_7_end" style="overflow:hidden;"><span id="mce_9_end" style="overflow:hidden;"><span id="mce_10_end" style="overflow:hidden;"><span id="mce_11_end" style="overflow:hidden;"><span id="mce_13_start" style="overflow:hidden;"><span id="mce_14_start" style="overflow:hidden;"></span></span></span></span></span></span></span><span id="mce_6_start" style="overflow:hidden;"><span id="mce_7_end" style="overflow:hidden;"><span id="mce_9_end" style="overflow:hidden;"><span id="mce_10_end" style="overflow:hidden;"><span id="mce_11_end" style="overflow:hidden;"><span id="mce_13_start" style="overflow:hidden;">and then I want &#39;Biweekly&#39;<span id="mce_14_end" style="overflow:hidden;"></span></span></span></span></span></span></span></span></span></p> <p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_3_start" style="overflow:hidden;"></span>This is what I have, but it won&#39;t let me have spaces in the name<span id="mce_12_start" style="overflow:hidden;"></span> </span></p> <p><span style="overflow:hidden;"><span id="mce_17_start" style="overflow:hidden;"></span><br /></span></p> <p><span id="mce_0_start" style="overflow:hidden;">Iif([Activity.Comments]=Lawn Service (25),&#39;Biweekly&#39;,&#39;Weekly&#39;)<span id="mce_21_start" style="overflow:hidden;"><span id="mce_23_start" style="overflow:hidden;"></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><br /></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">What am I missing?</span></span></span></p>