I tried converting the tables stored as text in the join as follows
with no luck:
([Table1] INNER JOIN Tables2 ON [Table1].Policy_Number = val
Any ideas on how to join these tables in the query? Thanks.
That is a typo. the SQL is ([Table1] INNER JOIN Table2 ON
[Table1].Policy_Number = val(Table2.PolicyNum))
Try something a little different with the SQL and how the fields are joined.
FROM [Table1], [Table2]
WHERE [Table1].Policy_Number = Val(Table2.PolicyNum)
One second! What kind of tables are they linked to? It's possible that you
can't run a function like VAL against it if not Access.
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County