If you use a group by clause, you must explicitly list all the fields not in aggregate functions. Since you have specified * (which is implictly all fields in the table), you will need to include all of these fields in the group by clause.
sum(Value) as [Value (S$)]
Resident FinalTable group by Store;
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein