[Solved] Total column or field issue

[KLeabu46]

Hello,

I am making a database to simultaneously handle inventory, sales and other aspects of running my business. I have a list of items on a table, each with their own MSRP, Sale Price, and Cost to the business. I would like to have either new columns with total MSRP, total Sale, and total cost, or have these appear in fields on a form. I cannot figure out how to do this. Any thoughts?

[UnklDonald418]

Maybe this tutorial will help
viewtopic.php?f=83&t=29194

[oneindelijk]

You can add views in your database which can contain extra columns
ie.
CREATE VIEW 'Totals' AS SELECT *,t.value * t.amount AS total FROM table AS t
You can then use a subform that displays the 'extra' data from the record

[charlie.it]

I am making a database ...

Ciao, can you attach here your database?

[KLeabu46]

Thanks guys, I was able to figure out how to create the total from a view using the above information!

Cheers!