I have a series of three reports with similar data. One of the fields is Gender, and it has three possibilities: m, f, or unspecified.
My problem is that one of the reports' underlying queries does not return any records with the value "unspecified", since none of that particular recordset have that value. So when I make that query the underlying query of the report, I get the message when I run the report that the MS Office Access database engine does not recognize "unspecified" as a valid field name or expression. The report needs to have that field, though, in case any future records have the "unspecified" value for the field.
How can I get the report to recognize that field? I'm sure I have to do something to the underlying query, so here is that query:
Thank you!
My problem is that one of the reports' underlying queries does not return any records with the value "unspecified", since none of that particular recordset have that value. So when I make that query the underlying query of the report, I get the message when I run the report that the MS Office Access database engine does not recognize "unspecified" as a valid field name or expression. The report needs to have that field, though, in case any future records have the "unspecified" value for the field.
How can I get the report to recognize that field? I'm sure I have to do something to the underlying query, so here is that query:
Code:
SELECT qryDemographicInfoAllStudents.StudentID, qryDemographicInfoAllStudents.Gender, qryDemographicInfoAllStudents.Ethnicity, qryDemographicInfoAllStudents.Age, tblPairAssignment.AcademicYr
FROM tblPairAssignment INNER JOIN qryDemographicInfoAllStudents ON tblPairAssignment.StudentID = qryDemographicInfoAllStudents.StudentID
ORDER BY qryDemographicInfoAllStudents.StudentID;
Thank you!