Hi,
I am designing an access table where two fields are integer fields. A third field also an integer field is the multiple of the first two integer fields. Is it possible in an access table to add the contents of two columns and automatically update the third column. i.e price per column item £5, total number col 6, total cost col £30.
I dont mean through expression builder and a query generated table. Rather I mean in a generic table so that when the user enters the price and the total number then the total cost column automatically updates.
I have used access queries a lot in the past but this is my first time actually designing a database from scratch.
thanks Willie
I am designing an access table where two fields are integer fields. A third field also an integer field is the multiple of the first two integer fields. Is it possible in an access table to add the contents of two columns and automatically update the third column. i.e price per column item £5, total number col 6, total cost col £30.
I dont mean through expression builder and a query generated table. Rather I mean in a generic table so that when the user enters the price and the total number then the total cost column automatically updates.
I have used access queries a lot in the past but this is my first time actually designing a database from scratch.
thanks Willie