Query field returns Expr1011

[kfox]

I have queried 2 tables,

• 1st table-"13-14 enrollments" with student enrollment information with a field titled "homeroom"-
• 2nd table-"Teachers"-whose primary key is "homeroom" with a unique classroom name assigned.
  
  • I have created a relationship b/w 2 with fields in these tables.

I then designed a form with a combo box linked to the homeroom name. When I run the query in the field that displays homeroom "Expr1011" is now the field name but in design view, the field name is still "Homeroom". Why is this?

Help!

[June7]

That usually means one of a couple of things:

1. same field is pulled into the query twice

2. a calculated field