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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report asks for Parameter and Won't Display Subreport 7
Access How to prevent subReport from breaking across pages? 1
Header Problem (page header & report header) 2
Reports/SubReports 2
Reports and SubReports Spacing 6
Page header in subreport does'nt repeat 1
Overlapping Subreports - Ms Access 2007 5
Report and subreport question 2

Back
Top