>Here's my example:
>
>I select the data I want included in the report to follow.
>
>SELECT mytable.&cField FROM mytable ;
> WHERE .... ;
> ORDER BY mytable.&cField ;
> INTO CURSOR rpt
>
>SELECT rpt
>
>I run the report.
>
>REPORT FORM MYREPORT.FRX TO PRINT
>
>In the report designer I want to use rpt.&cField as one of the fieldnames in the report, but it calls it a syntax error. Any work around for this one?
>
>I predesigned the report form using the report designer and supplied fieldnames at that time.
You'd be much better off having your SELECT statement use AS clauses to assign names to the desired fields. In general, the more you avoid macro expansion, the less trouble you're going to encounter. In this case, using macro expansion in the report buys you absolutely nothing.