Search results

  1. A

    Deleting duplicate records from an append query when the key is Autonumber

    I have a table with the following fields - Appeal #(Auto Number), Student ID, Class. I want to append records from an identical table and then delete the duplicate records (or not append the duplicate records in the first place). The trouble is the only single unique key is the Auto Number...
  2. A

    Simple append query validation error

    I am trying to append records from one table to an identical table, yet I keep getting a validation rule error message. I have looked time and again, and the design of the two tables seem absolutely identical. Can anyone think of something I am overlooking?
  3. A

    Lookup combo box

    Hello, I would like to create a combo box in which one could enter a student identification number(not the key field) and display the whole record if the student is in the database. If the student is not in the database, I would like to display a message box saying something such as "Student...
  4. A

    Automaticaly fill in a field based on another filed.

    Can anyone tell me if I can do this? Let's say I have a form with two fields: score and grade. I want to fill in the grade field based on data in the score field, for example if I enter a value between 90 and 100 in the score field, "A" would automatically be entered in the grade field. If I...
Back
Top Bottom