>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

You can go around the problem by running the query in two steps:
1. You create view/cursor combining two fields Manager,Employee into one.
2. You run cross-tab query having new field as row identifier.