View the total for a selected range

[Marc]

Hi, I input data on an access database and was wondering if I could get a quick and dirty total of a selected range just like in excel. In Excel when you highlight a range you get a sum in the status bar. Does Access offer something similar? I just need to verify totals quickly. Regards, Marc

The numbers run in columns.

 

[garyd1234]

You mean you are going into a table in an access database? No a table in access is not like a spreadsheet. It has no functions. It just stores data. You would need to create a report in access to tap that table and pull out the data range you want and add it up- your own formula type thing.