Alternative to GROUP BY ALL (sql server) in Access

[sandokan]

I'm trying to use a GROUP BY ALL function in an access database migrate
from sql server. Is there any alternative to the GROUP BY ALL function
in access??

 

[John Spencer]

As far as I know, you have to list each field in Access SQL - That is there
is no equivalent to Group By All.

 

[peregenem]

I'm trying to use a GROUP BY ALL function in an access database migrate
from sql server. Is there any alternative to the GROUP BY ALL function
in access??

Yes: writing non-proprietary SQL <g>. For details, see this Usenet
archive thread:

http://groups.google.com/group/micr...9ec16d5b363/0bef2762154b3fc7#0bef2762154b3fc7