calculating field

[dkbrostyle]

Hi I would want to create a table which calculates the expenses made.
I have created a table with all the prices on, and also created a table called list with the headings on.

what i would like to be able to do is that type in number 2 in the list table and also have a total on the list table. As the number is typed it would multiply it with what is in the price table. e.g. if price was 2*5 would be ten. Also there would be other fields which might require a number typed in the list table for example 2 mars bar, 1 coke, 3 bubble gum. Each one would be calculated with the price column and then shown on the total section of the list.

At the moment i have basic skills and i've been told that this can be done with the use of a query and forming relationships with the tables.

Thank you for your help and time.
(if possible could you create a sample proto-type of the database and send to me via email please )

Email address is dkbrostyle@yahoo.com

 

[Ziggy]

Post your table/field names so we can give you an example you can relate to and to ensure you have the right structure

 

[jmersing]

You may want to take a look at microsoft.com templates They have some functional databases that you can download, and there are even a few in Access itself just goto Access select new, and then select a pre written template. I believe there are a few that demonstrate just what you are looking for in forms and reports. Try the Invoice Tracking mdb