calculations in a report

[Cillies]

Does anyone know if it is possible to hide results in a report 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" in the query and that would be that.

But say you wanted to hide the company but still show their 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

 

[dynamictiger]

I think you could add a field like

Iif([CompanyName]="Company Name I dont Want","",[CompanyName])

This would replace the company name I didn't want with an empty string.

HTH

Does anyone know if it is possible to hide results in a report 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" in the query and that would be that.

But say you wanted to hide the company but still show their 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