Grouping a report

M

Mac

I have a query which has 4 fields.. say Company, Sector, Industry Group and
Industry. I have a report with a grouping in the all 3 levels (i.e, Sector,
IndustryGroupp and Industry). What I need is to limit the grouping. For eg.
My sector ID's are like 10, 15, 20, 25, 30, 35 etc... The report should
group .. if my Sector IDs are Less than 20 I need all the grouping as it is
now (all the 3 level grouping) but when the sectorID is Greater 25 then I
want to stop/hide the 3rd level grouping (i.e Industry Level). Is this
possible? Either by a code or function??


Thank you very much for the help and highly appreciated.

Mac
 
M

Mac

Thank you guys. I have solved the problem by making visible property of
group3 false

Thanks


Mac
 

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

Total Values 5
repeating subreport header on report 0
Grouping and Sorting a Report On Open Event 3
Dynamic Group Report 2
dinamic grouping level report 3
How do I add a grouping level to an existing report in Access? 1
Multi level grouping in a report 2
Grouping a Report made with a cross tab qry 11

Top