If you intended to post in a Microsoft Access-related newsgroup, you need to
understand that MS Access is a relational database, not a spreadsheet on
steroids.
How you'd do something in Excel is something you'll need to UNLEARN before
trying to get Access to do things.
If you need to add rows/columns of values, why not use Excel?
Regards
Jeff Boyce
Microsoft Office/Access MVP