Show or Hide Group By Header - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Show or Hide Group By Header

Todd Redeker

5 years ago

If the sub-group has more than 1 entry..

Goal - The report has calculated fields in the HEADER of the GROUP on Reinsurer

The goal is to only print this header when there is MORE THAN ONE "Issuing_Dealer_Name"

In the data, Corinne has 2 dealers. Therefore I want to print the HEADER of the GROUP on Reinsurer

Adam has 1 dealer. Therefore, don't print the Header of the Group on Reinsurer

Therefore, what code goes into the "On Format" event of this header?

	Todd Redeker OP @Reply 5 years ago

	Todd Redeker OP @Reply 5 years ago
here's some additional clarification: the DCount() returns a number that is the total rows in the entire dataset. I need the number of DISTINCT dealer_names within this Group on section. The dataset has a line for every contract signed. A dealer could have 1 sale or many. Therefore the rowcount wouldn't work in this case.

	Todd Redeker OP @Reply 5 years ago
I resolved this by creating a make-table query with a select distinct clause. Then I referenced this new table in the DCount function. It works. Once I have time, I'd rather use an array to minimize report creation resources used.

	Richard Rost @Reply 5 years ago
Good job. You could just try using COUNT instead of DCount.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View