Hi I am a self thought in access and been creating a couple of data bases for my farm.I am now building a attendance register and is keeping it as simple as possible.Table is as follow:
id(auto) : Date (=now()) : Employee 1 : Employee 2 : Employee 3 ................
What I need is to insert the value 1 into the field when a command button is clicked.The plan is to make a command button with the employee's picture on it that needs to be clicked for attendance.I am working with un schooled staff that doesn't know any thing about pc's.
The expression that I have tried is : on click : = [employee 1] = 1 but with no luck!