August 18, 200025 yr Newbies is there a way to put a "+" before positive numeric fields also.. is there a way to find a range if the values are reversed? i.e. "40..20" would find the same as "20..40" instead of only finding "40" thans
September 19, 200025 yr You may want to use a calculated field... For example, if you want to show the "cost" field as positive or negative you could use the following calculated field... c_t_cost_display calculation(text) =If(cost > 0, "+", If(cost = 0, "", "-")) The preceding field definition displays the cost field as positive (+), negative (-), or zero (). I hope this helps you... The problem is that this field cannot be edited. It gives you the look your looking for though... Clark! [This message has been edited by fishma (edited September 19, 2000).] [This message has been edited by fishma (edited September 19, 2000).]
October 17, 200025 yr As for the 40...20 issue: Set the range into a global text field, and enter find mode. Then parse the field to look for the numbers preceeding and following the elipsees (...), do a comparison between the two, determine which is larger, and reset the field to the proper order (20...40). Perform your find. This is a very quick parse and reset. If you need more details, let me know... Fishma!
Create an account or sign in to comment