Crosstab without Row Header

[Jefftopia]

I am attempting to build a query which has the names of people going across the top as my column headers and their account balances as values beneath each of the respective account holders.

The problem is that while I can use AcctHolder as my ColumnHeader and AcctBal as my Value in a crosstab query, I do not know what to assign for a RowHeader.

Anyone? thx ahead.

 

[DBAMJA]

I think this will work, I haven't tried it myself but it should work.

In your query builder where the field name goes type:
Balance:"Account Balance"

then set this to group by and as the rowheader.

Hope it works for you.

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[Jefftopia]

Thx. Wrks Great! Kicking myself for not thinking of it. I think I need another cup of coffee.