Recent content by AndrewG

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

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?

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

to DCX693 Your Previous Reply Thank you for your previous reply. I made the query as you instructed. May I ask you to explicate a little on the last paragraph of your solution? "To use this query in your form, place a reference to the form filed inthe criteria line for the StudentID, and bind...

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