crystalfun
Programmer
I'm used to writing crystal reports where I can suppress data if certain criteria are met. This is easy in Crystal. Is there a way to do this in Access?
I have a report where the group header has a project #, the detail has company, dept, account, and balance of account. The group footer has the subtotal of all of the account balances - subtotaled by project number =Sum([Balance]). I want to suppress all detail related to the project number in the group header if the =Sum([Balance]) in the group footer is < 100,000. How can this be done in Access? Thanks.
I have a report where the group header has a project #, the detail has company, dept, account, and balance of account. The group footer has the subtotal of all of the account balances - subtotaled by project number =Sum([Balance]). I want to suppress all detail related to the project number in the group header if the =Sum([Balance]) in the group footer is < 100,000. How can this be done in Access? Thanks.