Results 1 to 3 of 3
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Report exclude those records that have nothing in subform

    I'm making a report that lists bookings in a subform for each record

    If a school doesn't have bookings - I'd like the page not to show/be printed.



    Is there a fast way of skipping a current record if it's sub records = 0?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    nevermind, grouping in query... sorry

  3. #3
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You will probably need the Grow/Shrink as well as something like;

    If Me.Textbox=" " or IsNull (Me.Textbox]) Then
    Me.LabelName.Visible = False
    End If

    HTH

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

Similar Threads

  1. Exclude duplicate records when counting in a report
    By Fuzz_cozens in forum Reports
    Replies: 8
    Last Post: 02-14-2014, 02:16 AM
  2. Query to exclude non matching records
    By L1882 in forum Queries
    Replies: 1
    Last Post: 04-03-2012, 08:44 AM
  3. Replies: 4
    Last Post: 10-25-2011, 10:07 PM
  4. Replies: 2
    Last Post: 10-08-2011, 06:33 PM
  5. Exclude records within same criteria
    By brooke48 in forum Queries
    Replies: 14
    Last Post: 05-15-2010, 02:15 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