S Susan Oct 24, 2003 #1 How do you add costs in a column, sub-total and then grand total? How do you add heading to report?
L Lynn Trapp Oct 24, 2003 #2 You calculate the costs by using the Sum() function. IN your case you would use Sum([Costs]), or whatever your field name actually is. To get subtotals and grand totals you need to search Help for Grouping in Reports -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp
You calculate the costs by using the Sum() function. IN your case you would use Sum([Costs]), or whatever your field name actually is. To get subtotals and grand totals you need to search Help for Grouping in Reports -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp
