I've recently switched from developing in MS Access to MS Visual FoxPro
5.0. I'm very happy with what I've seen so far, but I've got one situation
where FoxPro seems to have a weakness when compared to Access. I am trying
to write a cross tab query to total hours used by account for employees and
managers. I would like the output of my query to look like this:

Account 1 Account 2 Account 3

Manager Employee

Mngr1 Emp1 8 7 2
Mngr1 Emp5 1 2 4
Mngr1 Emp7 4 0 8
Mngr2 Emp3 9 9 9
Mngr2 Emp4 9 7 0
Mngr3 Emp2 0 0 9
Mngr3 Emp6 9 2 4
Mngr3 Emp8 3 5 3

This would require Account to be the column header, sum(usage) to be the
data, and Manager and Employee to be the row specifiers. Access has no
problem with this but FoxPro's query designer won't let me put more than
one item in the row specifier box. I'm very happy with FoxPro so far but
why is it that Access has this feature and FoxPro does not? Am I missing
something?

Thanks in advance,

Brian Hartin
MCI Telecommunications
Brian.Hartin@MCI.Com