Search results

Thanx rain, d link was very helpful ��

Well I was trying to add the product of two fields in another field. I decided to create a query and then calculate the fields in there. But now I want an update of quantity on hand each time a quantity is ordered.

Auto update fields So I have a field in a table named quantity on hand which I want automatically updated after every transaction. I'm using access 2007. How do I? Pls need some help!!!!! Thanx

Thanx pngbill I'm using access 2007, I have fields qty sold, unit price, total price. I want my total price field to comprise of unit price * qty sold. If I must use a query how do I put the calculated field into my table. Pls

How do I create a field that consists of two other multiplied fields. Don't want to use a query. Pls