Data Types from different sources?

[bsnapool]

Hi,

Wondering if anyone has a solution for my problem.

I have 2 data sources, one which is an ODBC and one which is an import table. I have a 2 queries each querying the 2 data sources seperatly.

My problem is... One of the fields which I need to do a join to a reference table has a different data type in each of the data sources. I have tried changing this in the imported table NO JOY!! You cant change the data type in the ODBC link.

Is the anyway round this?

Any help appreciated...

 

[Dennisk]

you can convert one of the data types in the JOIN statement though.

 

[bsnapool]

What function would i use for this?

 

[neileg]

Depends. If for example you had a numeric ID held in a text field you could use CInt() to make it an integer. All the type conversion functions start with C so have a look at the alphabetical list of functions in Access help.

 

[bsnapool]

Thanks for your help... Will post back when sorted.