ERROR "Type mismatch in expression"

[jessiep]

I am trying to add 3 new fields to my report. The 3 new fields are from a different Table. I am getting an error " Type mismatch in expression"

MainTable
TaskID -AutoNumber
Status - Memo
OnTarget - Yes/No
Expected Completion Date - Date/Time
POC - Text
Description - Text

EmployeesTable
POC - AutoNumber
LastName - Text
FirstName - Text
EmailAddress -Text

In my report i would like to have the following infomation

TaskID / Status/ OnTarget/ Expected Completion Date/ POC /Description / LastName /FirstName /EmailAddress

SQL Statment: Query Builder
SELECT Employees.*, MainTable.*
FROM MainTable INNER JOIN Employees ON MainTable.POC = Employees.POC;


Jessie

 

[Matt Greatorex]

One POC is Text, the other is Numeric (and if had a dollar for every time I've done the same... )