Sum Calc

S

Steve

When I run the query below, it asks me to enter a parameter value for
Fin_Asst. before it completes the query. How do I get it to stop asking for
the value?

Below is the query:

SELECT SUM(Fin_Asst.Granted) AS [Sum of County]
FROM Fin_Asst
GROUP BY Fin_Asst;
 
B

Brendan Reynolds

Your query works just fine for me, provided that 'Fin_Asst' is the name of a
field within the table as well as the name of the table. The query wouldn't
make sense if 'Fin_Asst' was *not* the name of a field.
 
Top