To display or not to display...detail

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

Guest

I'm creating a report to show totals of various categories of product in the
report footer. Is it possible to show the detail of one category, but not
show the detail of another?

For example: A project contains products from 3 categories (A, B, C). I
only want to see the sum of A and C, but want to see the line by line
"detail" from category B.

Out of the categories of products, we would always only want to see the
detail of the same 1 or 2 categories.
Thanks in advance for feedback!
 
You can use code in the On Format event of your detail section that
references a bound value in your detail section ie:

Cancel = Me.txtCategory <> "B"
 
Back
Top