converting data types with linked tables

[c19h28O2]

Hi,

I have 2 linked tables, I would like to join these tables in access, however the first table's field is a memo and the second table is a number. I have tried to cint() the field in a query but I get an error message "Explicit conversion from datatype text to smallint is not allowed"

Any ideas how to get around this problem?

Thanks

Michael

 

[Rabbie]

It would be helpful to know why you think a number field would equal a large text field. I think you might find it useful to read up on relational database design

 

[c19h28O2]

Rabbie,

Thanks for the reply.

I didn't design the database or the tables that I am trying to join, In an ideal world they would both be a number but as I say I had no input on the table design.

So back to my original question, is it possible to convert (in access) a memo field to a number to allow joins on tables where the data types are not the same but the same data is held.

Thanks

Michael

 

[neileg]

A memo datatype is a bit different from other datatypes. Does this memo field really only have numbers in? You might be able to convert this to a number using the Val() function in a query and join the query to your other table.

 

[ajetrumpet]

Just thought I would pop in here...I've never tried to convert data in Access alone, but I have done it to linked Excel data. Just a thought...here is Microsoft's link for this if you want to try it...
http://support.microsoft.com/kb/291047/en-us