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?
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?
nevermind, grouping in query... sorry
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