Search results

  1. A

    Sort order:General problem convert to 2003

    I created a simple 2010 access database but my business PC with Acess 2007 couldn't open it. " Unrecognized database format "filename ". I tried to convert it to 2000-2003 format but it cannot do that either "The specified database sort order , General, is not supported for the target...
  2. A

    Counting specific characters in fields

    H1 H2 .... represent Hours of class. (greek educational system). which means that if the student missed the 3 first hours of class without excuse i add to the record (after student_id, absense_id) : .... H1 H2 H3 H4 H5 H6 H7 A A A I...
  3. A

    Counting specific characters in fields

    first sorry for the filed names you're right ! so you say i should have 2 tables : TABLE 1 Absense_ID Student_ID Absense_Date TABLE 2 Details_ID Absense_ID H1 H2 H3 H4 H5 H6 H7 ??? But what's the difference??? Memory or storage is not an issue. This database...
  4. A

    Counting specific characters in fields

    Thank you, I'll try that !!
  5. A

    Counting specific characters in fields

    Hi there, i have this problem: I have a Table with the fields: ID Student_ID Date h1 h2 h3 h4 h5 h6 h7 the last 7 fields hold one these values: A , B, C, D or empty example ID Student_ID Date h1 h2 h3 h4 h5 h6 h7...
Top Bottom