Subject Using COUNT(*)
Author quinton_marks

I want to use Count(*) in my Select Statement with other fields
eg. Select Field1, Count(*) FROM TABLE 1

but I keep getting a Dynamic SQL Error : Invalid column reference on
line 1.....

If I take the Count(*) out it works fine. This also applies to all
Aggregate functions SUM, AVE etc.

Anybody got an Idea?

Thank You in Advance