crosstabs in access repeat data titles. e.g if crostabbing for hours within
days, the resulting crosstab would have monday, 00:00; monday, 01:00... a
pivot table only pus that title once ona table so it would be monday, 00:00;
<balnk, 01:00. i want to get pivot tables to repeat teh titles so it looks
more like a crosstab. i

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create the table with a heading on each row, you can copy the table,
paste it as values in another location, and fill the blanks:

http://www.contextures.com/xlDataEntry02.html

skeekath wrote:
crosstabs in access repeat data titles. e.g if crostabbing for hours within
days, the resulting crosstab would have monday, 00:00; monday, 01:00... a
pivot table only pus that title once ona table so it would be monday, 00:00;
<balnk, 01:00. i want to get pivot tables to repeat teh titles so it looks
more like a crosstab. i


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html