quinton_marks wrote:

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

select field1, count(*) from table1 group by field1

> 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?

You should take some time and learn SQL. You will benefit from it later.

--
Milan Babuskov
http://fbexport.sourceforge.net