I am trying to learn how to use Access 2007. I have a db set up that maintains some student information. I have a main table that pulls the student names from a student table. I am trying to create a query that filters the main table based on a particular student. I cannot seem to get the relationships set up correctly so that I can use the students name instead of the students ID (primary key on the Students table). If I use the students ID it works fine but it I use the students name (in quotes) I get a "Data type mismatch in criteria expression." message.
The relationships are set up as follows:
Main Table: StudentName Field is related to the Students Table: ID Field
I hope I have explained this well enough that someone can help me. I am sure I am missing something obvious, but I can't figure out what it is.
The relationships are set up as follows:
Main Table: StudentName Field is related to the Students Table: ID Field
I hope I have explained this well enough that someone can help me. I am sure I am missing something obvious, but I can't figure out what it is.