Access report - create totals

Microsoft Access report used for stock take valuation. Report grouped by stock code. Need a calculated expression in stock code footer section, and same in category footer and report footer. Expression would be value from detailed section minus **sum total** from another field. The result of this calculation would then be used in the stock code footer section to multiply this value by the average stock price. This answer would only include values > 0. Also need filter to hide stock_code footer section if this result if zero. On report header I would like to display the date runtime query value. All dates are UK format (dd/mm/yy) Database is Access 2002. Would prefer solution without AccessVB code (so I can adapt it) but if there is no other way [login to view URL] ok. Would like project complete within 24 hours. Field details in stock code footer: SumTransQty = sum(TransQty) NetStock= QTY_IN_STOCK -(SumTransQty) Valuation = NetStock* AVERAGE_COST_PRICE Looks simple but is taking me ages to figure out... ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP Access 2002 UK date format (dd/mm/yyyy)