>>I guess you have the wrong file or alias name when the report form executes. Because based on your latest data, the SUM is 1200.
>>Try to check the alias at the deactivate method of the form.
>>Another possible solution, just group the SELECT by name to get the 3 rows only, bec. as I understand, you're just trying to get the unique rows right?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."