Calculating Totals in table

[jody frazier]

I'm trying to come up with a design for a database. This db will keep track
of certain documents turned in to a department in my company per week. I'm
not sure how to calculate in Access in tables.

So far I have a flat table with this info in it-

*Manager
*Date (Week ending date)
*Document1
*Document2

Is there a way I can add a "Total" field like in Excel?

Any advice?

 

[Rick B]

You don't. Use a query/form/report if you wish to calculate totals from a
table.

 

[jody frazier]

Which would be better? Query/Form/Report?

Thanks!

You don't. Use a query/form/report if you wish to calculate totals from a
table.

 

[Rick B]

It depends on what you are doing. Each of those objects has a different
purpose. If you are printing a report, then do it in a report. If you are
displaying data, then do it in a form or query.

--
Rick B

Which would be better? Query/Form/Report?

Thanks!