Search results

Thanks a lot, Mr theDBguy It helps me and solves my problems Thanks a lot again

Thanks for reply Mr theDBguy yes both table has the same number in teacher id field

Thanks for reply Mr theDBguy yes both table has the same number in teacher id field

Mr theDBguy When I join the both (Querry 44 and table Teacher Fine (with Teacher ID)) the query produced the same result The query expression is as under SELECT Query44.[Teacher ID], Query44.[T Att ID], Query44.[Teacher Name], Query44.Date, Query44.Absent, Query44.Late, [Teacher...

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...

Thanks a lot for giving me your prsious time Now the code is working Thanks again-

Run-time error 2580 is displayed with the following statement "The record source 'SELECT *FROM Teacher_Fine WHERE (([Teacher ID] Like "*2*"))' specified on this form or report does not exist.

No there is already a space in asterisk and FROM

yes I have a query named Teacher_Fine which is available

Mr. arnelgp Thanks a lot for the reply but the following error appears: "The record source 'SELECT *FROM Teacher_Fine WHERE (([Teacher ID] Like "*2*"))' specified on this form or report does not exist.

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...

Thanks a lot all of you for guiding me. I hope you all guide me also in the future. Thanks again all of you.

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...

Thank you for the for your kind response. I will try your suggestions.

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...

Mr arnelgp. Thanks a lot for helping.

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...

Thanks Mr. Arnelgp and Mr. plog This is working Thanks again. Now I want to counts the following fields (a) Rank (b) Marital_Status (c) Inactive Which expression is used for this counting, please help me. I will be great full to both of you. I request for help again. Thanks

I put this expression in text box

Thanks Mr. arnelgp when i apply DCount("[Rank]","Basic_Info","[Rank] = 'HS-I' and [Inactive] =False”) The message appears that "The expression you entered has and invalid string, a string can be up to 2048 characters long, including opening and closing quotation marks.