Search results

Yes pretty much. But I dont understand what I do to achieve this. And if I am ment to tackle this in the tables, or the queries or reports part of the database.

I have a table which contains 8 fields, each says for example.. Ingredient 1 quantity Ingredient 2 quantitiy Ingredient 3 quantity etc etc The values which i place in each of these fields, I want to total up and get the sum of all the ingredients, so i will have a field below saying the toal...

Hi I need to create a formula that will total up the values i have in several fields inside one table. How should I go about doing this? Am i ment to make a query? or do it in a form? Any help would be much appreciated