Totals In Tables

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi people...

I'm trying to save a total in a table that was created by
a query.

worked out by Qty * Cost = total

this is the total we want to store in the table.
 
Could you give more details on this? How do you want to store it? Running an
append query would certainly do the job of appending the info to a table
row..
 
Actually, it's considered a bad idea to store calculated results in a table.
Write a query that includes the calculation, and use the query wherever you
would otherwise have used the table.
 
I have a table called "Total" in this table i have 3 fields
"CableName","Qty" and "Cost".

I then created a query to work out the "Total"
(Total = Qty * Cost). Can i now store this "Total" in the
same table?.
If so HOW???

If not does it need to be stored in a different table?. If
so how again???

The only reason is because i cant get the "Total" when i
create a table.

NOTE: "Qty" and "Cost" are both inputted by external user,
then the "Total" should be calculated by the database.

If you are able to work out "Total" in the table design
this would be alot easier.

Thank you
 
You cannot calculate anything in an Access table. For that you'd use a
query. It is unnecessary to store data in a table if you store the elements
(quantity and cost) it can always be recalculated with the query. One should
never view data in the table anyway so the question of how you see it is
answered by using a form or report based upon the query that calculates the
data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top