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"
 
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 for Max, Ave & Detail Record for Highest Sale Price by Cate 1
Grouping not working right 2
create multiple details in a report 1
IIF function in Report Footer 5
Label for totals in group footer 2
query multiple records for a report 3
Code for end of detail section 9
Using "Sum" to add values from records in detail section 8

Back
Top