>Hi all,
>
>I am stuck (again). I am having issues using macro substitution in a Select statement.
>
>I want to re-use a select statement that collects data from 4 groups of 12 fields (1 for each month) and process it. The fields are all numeric data. I would like to pass 4 parameters (ince each group has a different field name prefix) to the method containing the Select statement and have it do the calculations to the 4 separate groups of 12. The field naming convention is ALPHA + Month number , ie. “XX1”, “XX2”, “XX3” and so on. I am thinking I can pass “WW”, “XX”, “YY”, “ZZ” as parameters and then concatenate the suffix (1-12) character value to the passed string and then do the Select. But my efforts have been fruitless.
>

You need a period between the variable and the suffix. That is, if your first parameter is cFirst, to add the suffix, you need:

&cFirst.1

Tamar