Hi there. I'm very new to MS Access so I'm sure this is a newbie-type question.
I'd like to know how to use a command button to perform a calculation on all records on a form without me having to physicaly select the records one at a time. An example would be, say, a calculation of current age using the DoB of each person in a "Person" table. I know I could use a calculated field but I don't want to go down that route. I just want the user to be able to click on a button and see the results for each record
I'd like to know how to use a command button to perform a calculation on all records on a form without me having to physicaly select the records one at a time. An example would be, say, a calculation of current age using the DoB of each person in a "Person" table. I know I could use a calculated field but I don't want to go down that route. I just want the user to be able to click on a button and see the results for each record