What I have found is that it picks or uses the last value for the field that it encounters, in the case of the Max function, it will choose the value attached to the record that meets the max condition, so it will work, but it is not really technically correct. A hidden feature!


>>You could also add posname to the view, which works with VFP sql but breaks ANSI Sql (all fields must be in the group by except summation fields).
>
>It works, in the sense that it won't err, but it does not pick the posname value from the right record. When it does it is a coincidence.