1 Reply Latest reply: May 15, 2014 9:59 AM by Dee Moore RSS

    Exporting Summary Fields

    Scott Blaylock

      I have a summary built with one field displaying across and all other data is listed down.


      A summary field is created for each "row" which is displayed to the right of the across columns that were created (like a crosstab query in Access).


      I'm wanting to export this data to Access, but it doesn't retain the summary column?


      Is it possible to retain this column during the export?

        • Exporting Summary Fields
          Dee Moore

          Hi Scott,


          Apparently the MS Access Jet is not formatting, or should I say recognizing, this field.


          I do have a work around for you.....


          Export to Excel, create a new database file in Access and Import the Excel data.


          It may seem a bit cunbersome, but it works.


          I'm sure this will be looked at.


          Dee Moore

          DWCH Tech Support