Search results

I have three tables named Teacher Attendance, Teacher, Teacher Fine Teacher Attendance table contains the following fields : Teacher ID Attendance Date Status School Timing Arrival Time Late Time Duration Remarks Teacher table contains the following fields : Teacher ID Teacher Name...

I have a form Named Teacher_Fine which contains the following fields: Teacher ID TeachFine_ID Date Absent Late When I put Teacher ID in the search box and click search it shows this error: "Run-time error 3075 Syntax error (missing operator) in query expression '((Teacher ID Like "*2*"))' I...

I have a table (Student Fine) that contains the following fields: Studend_ID Date Late Commer (Yes / No) Shoe not polished (Yes / No) Uniform not clean (Yes / No) Uniform not Ironed (Yes / No) Absent (Yes / No) At the end of the month, I want to count the total number of Late Commer students...

I have a Leave Record Table which contains following fields: (a) Worker_Name (b) Worker_ID (c) Leave_From (Beginning date) (d) Leave_To (End Date) (e) Kind_of_Leave (f) No_of_Days (g) Year_of_Leave (h) Total_Casual_Leave (j) Total_Annual_Leave (k) Remarks I want to calculate Total Casual and...

I have a form containing following fields:- (a) Leave_Code (b) Service_No (c) Leave_From (Leave Start Date) (d) Leave_To (Leave End Date) (e) No_of_Days (f) Kind_of_Leave (g) year_of_Leave (h)Total_C_Leave (j) Total_A_Leave (k) Remarks Now I want to calculate against a specific person...

I have a employees table which contains following fields:- (a) Rank (b) Name (c) Trade (d) Date_of_Induction (e) Marital_Status (f) Living_Status (g) Inactive (Check Box) when I enter =DCount("[Rank]","Basic_Info","[Rank] = 'HS-II'") in unbound box it counts all active & inactive employees, but...