Simple problem

[ca102960]

Hi All,

I hope you can help me.

The next statement works for MySQL but not for ACCESS:

SELECT db1.[field1], db1.[field2], count(id) as total
from db1
group by [field1]

Why?

Thanks.

[ADezii]

[field2] is not included as part of an Aggregate Function, this will work:
[CODE=vb]
SELECT db1.[field1], db1.[field2], count(id) as total
from db1
group by db.[field1], db.[field2][/CODE]

[ca102960]

thanks ADezii !!!!!!!!!!!!

[ADezii]

thanks ADezii !!!!!!!!!!!!

You are quite welcome.