Hiding Particular Attributes

[Cillies]

Does anyone know if it is possible to hide results in a query for a particular field.

i.e. if you had a field called company, but you didn't want a particular company to show up in your report. You would use <>"companyName" and that would be that.

But say you wanted to hide the company but still show there total figure in the report. i.e. I only want to see the unwanted companies total figure so as I can make comparisions at the end of the report.
Would that be possible.

Kindest Regards
Cillies

 

[SteveR77]

Cillies,


The simplest manner that I know of to do what you desire would be to set up a checkbox that could be set for excluding the company name in the report.


Then for the company name in the report set up an

IIF statement like this one -

IIF("[ExcludeCompany]=True","","[CompanyName])


So in the execution of the report the company names that you did not wish to see would be excluded but all of their data could still be used for calculations.

HTH,

Steve

 

[Cillies]

When you say use a check box where do I put it, is it in the form I use to open the report. If so do I change the VB code to control it?

Sorry if this sound really stupid!

Kindest Regards
Cillies