Hi Robert, Many thanks for pointing me to the url for Ralph's book. It's bringing back a lot of useful tools. I am bookmarking the location. As to converting the number to text, the correct format is "G999" in the apply.format function. Thanks and have a great day. All the best, Tony
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Robert Pollard Sent: Wednesday, December 09, 2009 7:01 PM To: [email protected] Subject: Re: [Dataperf] In need of some WD40 Tony There's a bookmarked copy of Mastering DataPerfect at www.dataperfect.info/mastering-dataperfect-bookmarked.pdf Meanwhile, I think you missed " " around A4, try: cat.c[ "ahspix" ; apply.format[ "A4" ; P1F1 ] ; ".jpg" ] Hope this helps Robert 2009/12/9 Tony Perez <[email protected]> Hello Group, My DP skills are very rusty. Ralph's book is buried somewhere in our garage after I moved from Texas to Northern California and am in need of a "jump-start" on a new app. I am building a one panel app with the following fields: P1F1 - a G9999:I to store picture #'s P1F2 - an A13 to store a filename for a picture in the current record to be formulated to result in "ahspix0000.jpg" I have tried the following formulas - neither one works: 1. cat.c["ahspix";P1FI (Selected, of course);".jpg"] - every record I create returns "ahspix.jpg" in that field ignoring the numbers I then thought I needed to convert the field to a text field and tried: 2. cat.c["ahspix";apply.format[A4;P1F1];".jpg"] which returns a "Word not Recognized" Error Message. I look forward to any thoughts on possible fixes. All the best to all, Tony _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf -- Robert Pollard Information Habitat: Where Information Lives http://habitat.igc.org/ [email protected] 1.212.864.3156 http://friendfeed.com/climatechange3 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.426 / Virus Database: 270.14.97/2550 - Release Date: 12/09/09 07:32:00
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
