strange query results 1

[simon551]

Hi,
I'm getting a strange query result that I don't know how to resolve.

This is my query, it references a field on a form as a result in the query. I have done this type of thing before with some success but don't understand why it is giving this result:

query:
SELECT tblClasses.ClassID, tblClasses.ClassNum, tblClasses.GroupID, [Forms]![frmStudents]![txtEmpID] AS Emp
FROM tblClasses
WHERE (((tblClasses.GroupID)=[Forms]![frmStudents]![Major]))
ORDER BY tblClasses.ClassNum;


The result for field 'Emp' is coming back "+".

On the form it is clearly a numeric value. Very strange. I'm trying it in another query and the result is simply ". Arghh.

Thanks in advance for any help.

 

[lespaul]

you can't select a value from a form, you can use a value from a form as a criteria. Change [txtEmpID] to the empID field in table tblClasses.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[simon551]

thanks