Calculating Totals in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You don't. Use a query/form/report if you wish to calculate totals from a
table.
 
Which would be better? Query/Form/Report?

Thanks!


Rick B said:
You don't. Use a query/form/report if you wish to calculate totals from a
table.
 
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



jody frazier said:
Which would be better? Query/Form/Report?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top