Results 1 to 9 of 9
  1. #1
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136

    Missing calculated values exporting to Excel


    I have a report in Access that I'm exporting to Excel. The values of 3 calculated fields don't export. They're just blank. Can someone tell me why?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Just offhand, causes don't come to mind. You could provide db for analysis. Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    your previous thread was about exporting a report formatted - is this the case here?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Are you exporting the query?

  5. #5
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136
    Quote Originally Posted by Ajax View Post
    your previous thread was about exporting a report formatted - is this the case here?
    This actually a separate issue.

  6. #6
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136
    Quote Originally Posted by ranman256 View Post
    Are you exporting the query?
    No, I'm exporting the report. Is that why?

  7. #7
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    yes. export the query to excel, the calc'd fields will transfer.

  8. #8
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136
    Quote Originally Posted by ranman256 View Post
    yes. export the query to excel, the calc'd fields will transfer.
    It's a long story but I really want to export via the report. It's weird, I have 3 calculated fields and two of them show in the export and two don't. They are all visible in the report obviously. Other than different formulas they're the same.

  9. #9
    matey56 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    136
    I found a workaround. I had to go in and add the calculated fields to the query. It's working now.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-23-2020, 02:33 PM
  2. Replies: 4
    Last Post: 05-22-2019, 02:09 PM
  3. Exporting data to Ms Excel Comma Separated Values
    By deepakg27 in forum Import/Export Data
    Replies: 20
    Last Post: 01-22-2018, 12:15 AM
  4. Replies: 1
    Last Post: 05-22-2017, 05:59 AM
  5. Option Values when exporting to Excel
    By dotcanada in forum Access
    Replies: 8
    Last Post: 08-24-2016, 08:08 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