Results 1 to 2 of 2
  1. #1
    joecamel9166 is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    85

    Add fields to report

    OK, so I know how to add fields to a report.
    What I am trying to do is add them on the fly.
    This report is for a packing slip.
    I have 11 fields on my main table, one field for each accessory that comes in with each unit.
    These fields are check boxes and 2 of them are text for misc. parts that come in.

    On my packing slip, I need to show that I am sending back the accessories that came in with the unit.


    So I need to display only the fields that have data in them.

    So for instance unit# 21 came in with a cord, cover, and drain. I need to display cord, cover, drain on the packing slip
    if unit# 25 came in with nothing, I need to say None on the packing slip.

    the only way I can figure out how to do this is to list all fields on the report and show the corresponding check marks, but that isn't acceptable.

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I believe that you have a normalization issue with your database. If I were to do this, I would have a main table for the Unit # and a sub table/form with the parts listed. Here is an example of what I mean.

    http://www.datapigtechnologies.com/f...subforms1.html

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

Similar Threads

  1. Replies: 17
    Last Post: 07-15-2014, 06:17 AM
  2. Replies: 1
    Last Post: 02-27-2014, 07:59 PM
  3. Fields On Report
    By Lois in forum Reports
    Replies: 2
    Last Post: 10-31-2011, 06:46 AM
  4. report fields
    By Lois in forum Reports
    Replies: 4
    Last Post: 10-28-2011, 05:45 AM
  5. Too many fields in a report
    By wsm_al in forum Reports
    Replies: 1
    Last Post: 10-17-2011, 03:29 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