Hi,
I have a problem with Group by Clause when i try to group some row data from table/view(try both)when create a view or query. The error msg prompt to me is (SQL: Group BY clause is missing or invalid.).Then, i just remove the group,but the msg still prompt to me. What wrong with it? Pls help me, i'm a beginer of foxpro. Thsnks a lot>>>

sean

Oh,is that have to insert the group as many as field insert to view? Y??