Results 1 to 2 of 2
  1. #1
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55

    Report Export to Excel

    access,
    I have a report that contains column totals. I have a macro setup to export this to excel. I realize the totals will not be exported because of the way I am using the unbound text boxes to calcuate them in the report footer.

    The strange thing is that when I manually total up the fields in excel they do not match my report totals. I have visually compared the report to the excel file and every record has been exported. This seems impossible!!!

    Any ideas?

    Thanks,


    Bruce D.

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    You must see the exact data stored in the number instead of seeing the
    formatted one in excel or access.

    Usually, excel mask the true data in decimal places.
    Also, decimal places in number make it not exactly the same as you want.

    For example,
    0.02 may not be exactly 0.02 but 0.0199999999999 instead.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro to export to excel
    By jlclark4 in forum Import/Export Data
    Replies: 5
    Last Post: 04-15-2011, 08:36 AM
  2. Export query to Excel
    By dev82 in forum Queries
    Replies: 15
    Last Post: 02-10-2011, 11:15 AM
  3. Replies: 3
    Last Post: 02-01-2011, 10:18 AM
  4. Export to Excel with OutputTo
    By kadara in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2010, 11:35 PM
  5. Export to Excel
    By vaikz in forum Import/Export Data
    Replies: 3
    Last Post: 03-25-2009, 09:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums