Results 1 to 4 of 4
  1. #1
    cparker1 is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2016
    Posts
    2

    Yes/No Field

    I am not able to export Yes/No Fields from a report to an Excel spreadsheet, they just don't transfer over. Is there a fix for this?



    Thanks!
    Cindy

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Import the excel sheet as is. It will have text values...yes/no.
    Afterward, in the table,add a field that is Boolean,y/n.
    run an update query to mark the Boolean field where of all text =YES

  3. #3
    cparker1 is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2016
    Posts
    2
    I'm going from Access to Excel - nothing transfer to Excel from the report that has the Yes/No field on it from the table. I need to know how to get the field to export/show in Excel.

    Thanks!

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Change it to a text field and in the record source for the report add a new field :IIf([Fieldname]=True,"Yes","No") or whatever values you want to display.

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

Similar Threads

  1. Replies: 6
    Last Post: 06-26-2015, 08:55 PM
  2. Replies: 17
    Last Post: 03-16-2014, 10:52 PM
  3. Replies: 3
    Last Post: 12-27-2013, 02:33 PM
  4. Replies: 1
    Last Post: 03-03-2012, 10:17 PM

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