Hi, I have a field that I list 5 items on with totals, also there is a grand total. Each item shows a percentage of the grand total. What I would like to do is subtract one item from the grand total then calculate percentages with the remaining. Please advise. By the way I am working with Access 97 reports.