This may be a simple question... :S
How do i make a field in a table update itself depending on the total values of a yes/no (or number) field in another table?
Like in Excel B3 "Sum = (A1:A10) <-- how do i do this sort of cell calculation in access?
I started by look at querys, a query to "count" the values in a field in one table, but then got stuck as there is no way to automatically apply this info.
it cant really be a macro/qry that runs on a command, as it should really update straight away like excel would.
Thanks.
How do i make a field in a table update itself depending on the total values of a yes/no (or number) field in another table?
Like in Excel B3 "Sum = (A1:A10) <-- how do i do this sort of cell calculation in access?
I started by look at querys, a query to "count" the values in a field in one table, but then got stuck as there is no way to automatically apply this info.
it cant really be a macro/qry that runs on a command, as it should really update straight away like excel would.
Thanks.