SQL Error

May 12, 2020, 08:21:18 AM

Hi,

Somebody please help me with this error.

I am trying to make a bar chart with this statement.

SELECT COUNT(h.hhid) AS count_of_males FROM hhoccupants AS h WHERE (h.gender ="M" )

After pressing OK button, I got this error. Tried so many possibilities but no success at all.

"Cannot Parse The SQL Statement. Error: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"

Can't identify the source of error specially this is just a Gender field with varchar(1) either "M" or "F"

Thank you.