command missing operand: <identifier>

  • Thread starter Thread starter matthew701
  • Start date Start date
M

matthew701

I'm getting the error message "command missing operand: <identifier>"
in MS Query when trying to added any group functions like sum or count.
Here's the SQL statement that's being generated by Query:

SELECT HC_CHARGES.CPT, HC_CHARGES.CPT_CODE, HC_CHARGES.POSTED_DATE,
Count(HC_CHARGES.CPT) AS 'Count of CPT', Sum(HC_CHARGES.CHARGE) AS 'Sum
of CHARGE'
FROM HC_CHARGES HC_CHARGES
GROUP BY HC_CHARGES.CPT, HC_CHARGES.CPT_CODE, HC_CHARGES.POSTED_DATE
thanks for any help!

Matthew
 
Is the data source MS e.g. SQL Server, MS Access/Jet, Excel etc? If so,
try square brackets e.g.
[Sum of CHARGE].

Jamie.

--
 
Back
Top