I was trying to bring down values from two different tables that have County(Numeric field) as a common field. But i am getting this error,
Run time error "3615", type mismatch in expression. I donno wat is the reason. Here is the snipet of my query,
SELECT dbo_hpr.ADDRESS, dbo_hpr.PROPNAME, Dbo_Bridges1.CITY, Dbo_Bridges1.ADDRESS
FROM Dbo_Bridges1 INNER JOIN dbo_hpr ON Dbo_Bridges1.[COUNTYCD] = dbo_hpr.[COUNTYCD]
WHERE (((dbo_hpr.ADDRESS) Like Nz(Forms!Prop_Bridges!comboaddr,"~") & "*"))
P.S: Here dbo_hpr - table1
Dbo_Bridges1 - table2
COUNTYCD is the Column name that exists in both the table. Can someone pls help me fixing it. Thanks in advance
Run time error "3615", type mismatch in expression. I donno wat is the reason. Here is the snipet of my query,
SELECT dbo_hpr.ADDRESS, dbo_hpr.PROPNAME, Dbo_Bridges1.CITY, Dbo_Bridges1.ADDRESS
FROM Dbo_Bridges1 INNER JOIN dbo_hpr ON Dbo_Bridges1.[COUNTYCD] = dbo_hpr.[COUNTYCD]
WHERE (((dbo_hpr.ADDRESS) Like Nz(Forms!Prop_Bridges!comboaddr,"~") & "*"))
P.S: Here dbo_hpr - table1
Dbo_Bridges1 - table2
COUNTYCD is the Column name that exists in both the table. Can someone pls help me fixing it. Thanks in advance