Sql Data Type 1

[JHerr]

Hi everyone.

I have an sql statment with MANY joins, but the one problem i'm having involves data type. i'm using this:

"tblInsCarrier Inner Join (("**other tables**&quot) On tblInsCarrier.InsAutoID = tblPatientIns.InsID"

the error i get is:
"Type mismatch in expression"

the problem is that the .InsAutoID field is an autonumber field, while .InsID is a text field in a linked table, with the actual table residing on a server and i cannot change it.
is there a way for me to convert it to a numerical field each time, without creating a new table or new field?
Thanks
-jacob

 

[tlbroadbent]

If InsID is always conains numeric data , you could use a VAL function to convert it to integer.

tblInsCarrier.InsAutoID = VAL(tblPatientIns.InsID) Terry

People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[JHerr]

Hey thanks! that worked great s-)