Make a subreport show up only if a field is >20

P

pokdbz

I have a subreport in the header of a form.
The main reprot is called: SummaryReprot
The subreport is called: PHQAlert
--Field on subreport: PHQTOT

Is it possible to only show the subreport if this field PHQTOT is > 20?
 
K

KARL DEWEY

Try using the the >20 in criteria of the query that is the record source of
the subreport. Set the Can Grow & Can Shrink properties to Yes. Size the
subreport in the header to a narrow line. With no records to display it
should not show unless it also has headers and footers.
 
Top