Have two tables linked from SQL server into Access '97, one
containing an autonumber primary key and the second table has a
text field populated with
cstr([autonumber]).
I can create a query that contains a calculated field
Cstr([autonumber]) and do an inner join on that to the second
table. I can also create a query containing a calculated field Clng
(textfield) and do an inner join to the first table.
But if I change the join to left or right, trying to view the query
gives me an error report "illegal join"
Any suggestions for a workaround, I really need a left join.
I am not allowed to alter the SQL server tables, and my bug reports
and suggestions for improvement are met with evil stares and worse
from the I.T. department personnel.
--
Bob Quintal
PA is y I've altered my email address.