Forms

Hello Sinal,

there are various ways to use formulas. One of the easiest examples to use is an on form formula. If you have a tabular form that shows more than one record on the form and you have a field that is numerical, for example Price then you can easily get a total of what is on the form by doing the following.

Go to design view and add a text box into a convienient space (you might be able to create space if need be by pulling out a bit of form space from the bottom edge of the footer bar). The text box you have created will currently be showing 'Unbound'. Over-write this with =Sum([Price]). Go to form view and you will see the total. You can use the label appropriately to show Total Value etc. If your field is not Price then put what ever its name is as it appears in design view on the form. The curve brackets is the way to use the Sum function--it tells Access to do a sum on what is in the brackets. The square brackets tells Access to look for a field name. You can alter the above equation or create a further text box as required, to do a different calculation. For example you may need to add VAT at 17.5% so you would insert =(Sum([Price]))*1.175

You can multiply two fields within a query to add a new column showing results against each record. If the field names are Quantity and Price then you would type into a new blank column in the query desing grid (a query having Quantity and Price columns in it). You would type into the top row the following. Total: ([Quantity]*[Price]) In this example you don't need sum because it is just a multiplication within each record line. I have mentioned Sum as an operator but there are many others available, which you can see via Help when you have Access open.

I hope this was helpful.
Mark