It's seems to me that it much easier to do with cursor but you can do it another way.
- Change expression in the label filed from say 'field1' to 'field1.myfunc(RECNO())'
- Create nyfunc function that returns string with Month + Year based on the parameter passed.
>So I guess there is no way to just place the month and year to a variable and tack it onto the actual field data?
>
>>The best way to do it in VFP is to prepare data before printing labels. You don't need to create new tables, you can use cursors.
>>
>>>I know this is simple, but can anyone help me out with some label printing.
>>>
>>>The first one is:
>>>
>>> I have a table that houses 4 records. These records will be printing on file folder labels (2 columns).
>>> a) how can I get the four records to print each record with the month and year attached to the end of it.
>>> (i.e., AP - January 2002, AP - February 2002, AP - March 2002, etc.). I created an dimension, but
>>> I cannot get it to work. I want to try to avoid creating a new table just for months.
>>>
>>> b) if a paper is half used, is there a method to skip down to the unused labels half-way down the page?
>>>
>>>The second on is:
>>>
>>> I have a table that has duplicates of names (sometimes 4 to 10+ times duplicated). I need to create labels for each of the names, but
>>> not their duplicates. I tried unique index, but it did not work. Is there anyway to accomplish this by not exporting data to a temp table?
>>>
>>>Thanks for any assistance!!
>>>
>>>Nicholas
--sb--