Data Type Mismatch, I Don't See it

[ALewis06]

If both sets of fields that are being joined are text fields, why is there a data type mismatch error?


SELECT qry932_SFADetailAddMRCNRC.DirFirstName, qry932_SFADetailAddMRCNRC.DirLastName, qry932_SFADetailAddMRCNRC.EmployeeNo, qry932_SFADetailAddMRCNRC.MgrFirstName, qry932_SFADetailAddMRCNRC.MgrLastName, qry932_SFADetailAddMRCNRC.MgrEmpNo, qry932_SFADetailAddMRCNRC.[Close Date], qry932_SFADetailAddMRCNRC.RevMoYr, qry932_SFADetailAddMRCNRC.[Expected Turn-Up Date], qry932_SFADetailAddMRCNRC.[RevTurn-UpDate], qry932_SFADetailAddMRCNRC.[Product Name], qry932_SFADetailAddMRCNRC.[SumOfIncremental MRC (converted)], qry932_SFADetailAddMRCNRC.[SumOfNet NRC], qry932_SFADetailAddMRCNRC.MRC_NRC

FROM qry932_SFADetailAddMRCNRC

LEFT JOIN tblSFAProductLookupwProdRevType ON (qry932_SFADetailAddMRCNRC.MRC_NRC = tblSFAProductLookupwProdRevType.MRC_NRC_ADJ) AND (qry932_SFADetailAddMRCNRC.[Product Name] = tblSFAProductLookupwProdRevType.ProductName)

GROUP BY qry932_SFADetailAddMRCNRC.DirFirstName, qry932_SFADetailAddMRCNRC.DirLastName, qry932_SFADetailAddMRCNRC.EmployeeNo, qry932_SFADetailAddMRCNRC.MgrFirstName, qry932_SFADetailAddMRCNRC.MgrLastName, qry932_SFADetailAddMRCNRC.MgrEmpNo, qry932_SFADetailAddMRCNRC.[Close Date], qry932_SFADetailAddMRCNRC.RevMoYr, qry932_SFADetailAddMRCNRC.[Expected Turn-Up Date], qry932_SFADetailAddMRCNRC.[RevTurn-UpDate], qry932_SFADetailAddMRCNRC.[Product Name], qry932_SFADetailAddMRCNRC.[SumOfIncremental MRC (converted)], qry932_SFADetailAddMRCNRC.[SumOfNet NRC], qry932_SFADetailAddMRCNRC.MRC_NRC;

 

[arnelgp]

i dont see any reason for the join, since your not using any field in table tblSFAProductLookupwProdRevType, either in expression or as criteria.

 

[plog]

The issue could be downstream--do you get a mismatch error when you run qry932_SFADetailAddMRCNRC by itself?

Also, since some of the data is coming from a query--are you sure the data types from that field are what you assume? When you run qry932_SFADetailAddMRCNRC how do the values in those joined fields align themselves? Left or right?

Just saw arnelgp's response and he's right--no point in tblSFA... being in there at all.

 

[ALewis06]

Both fields are left aligned. When I made the qry932 a make-table query then joined the two, both as tables then it worked. Why? Why didn't it allow to build a query on another query in that instance?