L
Lurch
Hi There!
Using Access 2000 on windows pro 2000. I have two linked tables (I
cannot change field properties for various reasons). I have placed
these two tables into a make table query but the joined fields are
incompatible. One is an autonumber and the other is text. Because of
this I get a "Type mismatch" error.
How can I change the property of the autonumbered field to text. Then
I can use another query to make the table I require.
Any help would be great!
Thanks!
Tony
Using Access 2000 on windows pro 2000. I have two linked tables (I
cannot change field properties for various reasons). I have placed
these two tables into a make table query but the joined fields are
incompatible. One is an autonumber and the other is text. Because of
this I get a "Type mismatch" error.
How can I change the property of the autonumbered field to text. Then
I can use another query to make the table I require.
Any help would be great!
Thanks!
Tony