Page 2 of 2 FirstFirst 12
Results 16 to 26 of 26

Suppressing records and minimizing row when there are null records

  1. #16
    Endora is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    13

    Angry


    Quote Originally Posted by June7 View Post
    Since the solution worked for me and I can't replicate your results, if you want to provide db for analysis, follow instructions at bottom of my post.

    I can's seem to attach the db. Get too large error.

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,401
    Did you run Compact & Repair? Did you zip it? 2MB zip allowed. If still too large can upload to fileshare site such as Box.com and post link to the file.
    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. #18
    Endora is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    13

  4. #19
    Endora is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    13
    Any luck with my database??

  5. #20
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,401
    The posted db doesn't show my suggestion was attempted in the report.

    I applied the settings as I suggested and it almost works. The first two records that don't have any support staff are definitely collapsed as you want but other records are inconsistent in the results.

    The only other suggestion is to concatenate all the support staff fields into a single textbox.
    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.

  6. #21
    Endora is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    13
    Which part did I miss? I put "Y" to shrink and grow. I zeroed the text box, but I kept going back. Do you think I did it in the wrong place?

    I have been struggling with this issue for several years!

  7. #22
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,401
    There is only the one report so I don't know where you did the modifications. Did you not provide the correct copy of db?

    Regardless, the idea fails. That leaves concatenation.
    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.

  8. #23
    Endora is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    13
    oh, gosh! I don't know about concatenation.

  9. #24
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,401
    Examples:

    [field1] & [field2] & [field3] & [field4] & [field5]

    [field1] & ", " & [field2] & ", " & [field3] & ", " & [field4] & ", " & [field5]

    [field1] & Chr(13) & Chr(10) & [field2] & Chr(13) & Chr(10) & [field3] & Chr(13) & Chr(10) & [field4] & Chr(13) & Chr(10) & [field5]

    IIf(IsNull([field1]), "", [field1] & Chr(13) & Chr(10)) & IIf(IsNull([field2]), "", [field2] & Chr(13) & Chr(10)) & IIf(IsNull([field3]), "", [field3] & Chr(13) & Chr(10)) & IIf(IsNull([field4]), "", [field4] & Chr(13) & Chr(10)) & [field5]
    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.

  10. #25
    Endora is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    13
    OMG! I am totally not up to par when it comes to this. Please bare with me.

    Exactly where would I put this, query or report?

  11. #26
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,401
    Expression can be in query to create a field then bind textbox to the constructed field. Or the expression can be in textbox ControlSource property.
    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.

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

Similar Threads

  1. records w/null
    By slimjen in forum Queries
    Replies: 6
    Last Post: 07-03-2013, 09:39 AM
  2. Replies: 8
    Last Post: 08-13-2012, 04:30 AM
  3. Suppressing records in a report
    By snowboarder234 in forum Reports
    Replies: 1
    Last Post: 07-11-2012, 07:52 PM
  4. Do not show null records
    By brobb56 in forum Forms
    Replies: 1
    Last Post: 09-23-2011, 02:29 PM
  5. Not showing records with null sum
    By eww in forum Queries
    Replies: 3
    Last Post: 04-04-2011, 03:10 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
  •  
Tech Forums: Microsoft Office Forums