I can see I'm going to have to.

I have discovered that I now need to have variables used in macro substitution decleared when I open the view (even when using the NODATA option). Short of declearing a public variable, do you know of any way I can make a varible 'visible' to the data environment when it is opened/created?

Geoff

>Geoff,
>
>I highly recomend to read what's new section in VFP8 and VFP9 help. VFP8 help is available online.
>
>>
>>I guess I can expect to miss a few things when I jump a whole version.
>>
>>Geoff
>>
>>>Hi Geoff,
>>>
>>>See Re: Change in SQL commands! Message #941774. The problem with you select is that yo didn't specify from wich record in a group values for i_key, and contractor should come. If they are the same for all records in a group, yopu can include them into GROUP BY clause. If you don't care from wich record those values comes, you can wrap those fields into MIN or MAX function. The solution depends on what result you want to get for those two fields.