Recent content by ijaz196

  1. I

    query returning duplicate rows

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

    query returning duplicate rows

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

    query returning duplicate rows

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

    query returning duplicate rows

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

    query returning duplicate rows

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

    Run-time error 3075 Syntax error in query expression

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

    Run-time error 3075 Syntax error in query expression

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

    Run-time error 3075 Syntax error in query expression

    No there is already a space in asterisk and FROM
  9. I

    Run-time error 3075 Syntax error in query expression

    yes I have a query named Teacher_Fine which is available
  10. I

    Run-time error 3075 Syntax error in query expression

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

    Run-time error 3075 Syntax error in query expression

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

    Question Counting

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

    Question Counting

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

    Sum of days using multiple criteria

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

    Sum of days using multiple criteria

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