Access doesn't have anything native that will get you that. You can "spoof" it with three union queries. SQL Server has some syntax for this (Pat - I'm thinking this is a requirement met by CUBE). No idea re Foxpro.
If this is for a report then it is A LOT easier and more efficient to do this in the report - forget the query.
Given the two applications available (Access and FoxPro) I would guess that this is a reporting need; in which case they can both do it very eeasily if you simply select the fields and group them on the report!
field1, field2 and field3 can go in the report deail section and then you can use aggregate expressions in the group section or footer sections as necessay.
In fact, yo may have to use a group by clause in your select statement...