Group BY - Maximum Fields

[carrionk]

Hi,

I've been trying to search for more information on this topic without
luck.

From what I've read, the maximum fields that can be used with GROUP BY

clause is 10. (this was an Access 97 Post)

Access 2002 also has this limitation? I'm currently working on a DB
where I'll have to group 18 fields...

Regards,
LC

[Tom van Stiphout]

On 24 Aug 2005 16:46:56 -0700, ca******@yahoo.com wrote:

Try it on a test-query and let us know what you find out.
-Tom.

Hi,

I've been trying to search for more information on this topic without
luck.

From what I've read, the maximum fields that can be used with GROUP BY

clause is 10. (this was an Access 97 Post)

Access 2002 also has this limitation? I'm currently working on a DB
where I'll have to group 18 fields...

Regards,
LC