470,641 Members | 1,590 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Group BY - Maximum Fields

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

Nov 13 '05 #1
1 1391
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Experienced but Undocumented | last post: by
3 posts views Thread by CSDunn | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.