need pivot tables to look more like crosstabs with repeating data.
 

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