Keep the name of the 12 fields constant and have 12 more fields which will have the expression of the first 12 fields.
I have a app where for workers get paid every fortnight. So id the fortnight is from 1st June to 14th June then my first 14 columns will be std. day1,day2,.....day14 which will be all numeric fields followed by date1,date2,.....date14 which will be date fields and will contain the date of the corresponding field. Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" -------------------------------------------------- From: "Sytze de Boer" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2008 4:33 PM To: <[EMAIL PROTECTED]> Subject: VFP9-reports > Sorry for such a basic foxpro issue, > Please help me out > > I have a table where the 1st column is a constant called CODE, but the > next > 12 columns will not always be called the same. > e.g., Depending on the period of the report, the 2nd column could be > called > C_2006_01 or C_2008_01 (3rd column same, etc) > > This is not causing me any issues (in fact this is how I want it) > But it becomes an issue when I want to print a report where I'm stuck for > expressions >>From the command prompt I can say repfld2=field(2) > It correctly returns "C_2006_01" > When I say ?&repfld2 , it returns the correct value (say $1000) > But a report won't accept an expression of &repfld2 > > Any suggestions are welcome > > -- > Regards > Sytze de Boer > Kiss Systems > Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 > www.kiss.co.nz > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
