Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. k2work

    Multiple DAP Pivottables - One Source Folder?

    Using Excel and Access XP and no programming in this procedure. I have a file of 20000 records with about 12 different column headings. I create a pivottable view and save as interactive DAP.. this produces the htm file and also a folder with the same name with the underlying data. This is...
  2. k2work

    DAP with pivottable limit?

    UPDATE I now realise that while working in the MS Access 202 "Pages" to create a dap, in either "design view" or "page view", your maximum grand total on your pivottable will not exceed 10000 (This is sort of a preview of the layout, but not completely accurate...
  3. k2work

    Excel 2000: Multiple Column Sums In Pivot Table

    Once you drag a data item into the data area you should click on the column heading.. now the autocalc button should be available (not greyed out). Click on the autocalc pull down and select SUM, Average etc... if you only see "COUNT" available within the list and the others are...
  4. k2work

    DAP with pivottable limit?

    I have created several Data Access Pages in combination with Pivottables... and all looks well until later in the day.. after several changes.. more than twice, the totals of my rows and columns changes from the accurate total of 22,141 to 10,000! If I create another DAP and pivottable...

Part and Inventory Search

Back
Top