I have a query with (Name) and (Amount). Then I have a button(on a form) that generates AutoReport based on my query. Can I add via VBA the Sum of the (Amount) in the report Footer. Regards
Sum of the Records via VBA
Novice
Windows 7 32bit 
Access 2010 32bit
I have a query with (Name) and (Amount). Then I have a button(on a form) that generates AutoReport based on my query. Can I add via VBA the Sum of the (Amount) in the report Footer. Regards
VIP
Windows XP Access 2010 32bit
No. However, try just calculating in textbox with: = Sum([Amount])
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Auto populate new child records based on subform records
Posting Permissions
Reply With Quote