I am having a problem which I hope someone can help with.
Our company has a Timeand Attendance system which records employee clockings. I am using Access 2000 to produce a "Roll Call" report which will show employees as "In" or "Out". I am working on the principle that an uneven number of clockings means they are "In" and an even number of clockings means they are "Out". I have found a function which is used for printing Odd or Even reports called 'Mod' but I don't know how it works.
Basically I need a function or macro that will evaluate the number of clockings on the system for an employee and decide that if the number is even then they are "Out", but if the number is uneven then they are "In"
Hope this all makes sense, and hope some can help.
Just set up another if statement to encolse your other ones i.e.
If Not IsNull(NoClockings) or NoClockings <> "" then
if (NoClockings mod 2)=1 then
'insert code for still logged in
'insert code for logged out
'case for null values
CurrentState=iif(noClockings is Not Null,"Clocked " & iif((NoClockings mod 2)=0,"Out","In"),"Null Clockings")