Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154

    Printing report with record that is not blank

    Dear all



    I have made a Report, there are around 6 fields. How can i make the report just to print the field that contact data and skip the blank

    Student Name
    Class 1
    Class 2
    Class 3
    Class 4
    Class 5

    For example

    Student A , take only Class 1, 2, 3
    Student B, take 2, 3, 4
    Student C, take 3, 4, 5


    Can i make a report to display like

    Student A
    Class 1
    Class 2
    Class 3

    Student B
    Class 2
    Class 3
    Class 4

    Student c
    Class 3
    Class 4
    Class 5

    Like this ?

    Eric

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the query, filter out the blanks:
    not null

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If I understand correctly, classes should not be fields in the table, they should be records in a related table (1 record for each class taken):

    Fundamentals of Relational Database Design -- r937.com
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Dear all

    I get to know that i can use the Shink and Grow property in the report.

    However, it does not work
    I wonder what went wrong

    https://www.dropbox.com/s/ci3lkg5k3x...row.accdb?dl=0

    https://youtu.be/7x3gXclFA0c

    Anyone would enlighten me

    Thanks

  5. #5
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    i tried it out in Access2010, it works
    the field will shink if the value is null.

    It raises another queston when i use columar format to display the data.

    it does not work how can i solve it ?Eric

  6. #6
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Dear all

    Any one have any advice . I get stuck...

    Eric

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Can you attach the db here? I offered advice to properly design the tables. The report could then easily be restricted to only showing classes each student took.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    pbaldy


    Please find attached link

    https://www.dropbox.com/s/ci3lkg5k3x...row.accdb?dl=0

    Million thanks

    Eric

  9. #9
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Dear all

    Any advice for me

    Eric

  10. #10
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Dear all

    Any help?!

    Eric

  11. #11
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I assume you're not interested in fixing the design? What are you going to do when there's a 7th class?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  12. #12
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Pbaldy

    I am very keen to get the answer just waiting for help while searching on the net for it

    i tried many time and the possible answer may be the "text"box is unable to shrink or grow while only the "Unbound" box can

    I have post the link for the file in Dropbox. https://www.dropbox.com/s/ci3lkg5k3x...row.accdb?dl=0

    The issue is, i have many classes to add for the student to sign up, it can grown.

    I need to do a summary, and if it would trim only the one with data would be great

    Eric

  13. #13
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Please review post 3. If you normalize the tables, it will all be easier.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  14. #14
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Pbaldy

    I just have few fields in the table

    Student
    Class 1
    Class 2
    so...
    if i need more class , i just to to table and add, and form to modify
    Query to add and convert to report

    But need the Report to show only class that be selected , otherwise, it will clumsy

  15. #15
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It's clumsy because of your design. A new class shouldn't require the database designer to change anything in the app.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 09-10-2014, 08:48 AM
  2. Replies: 1
    Last Post: 05-25-2013, 11:19 AM
  3. Replies: 1
    Last Post: 02-10-2012, 05:15 PM
  4. Printing Blank Report
    By andrewm in forum Reports
    Replies: 2
    Last Post: 11-24-2010, 05:30 PM
  5. Report printing unknown blank lines.
    By dgrzalja in forum Reports
    Replies: 10
    Last Post: 11-02-2009, 12:21 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