Matching DataTypes

[narineh]

Is there a way that I can check the datatype match between two tables with the identical Fieldnames. My problem is that one or more of the fields in my table that I am trying to append to is not matching Datatype.

Thanks

 

[mikey69]

Open each table in design mode, select the filed and you will see the field type in the property box at the bottom of the screen.

 

[narineh]

That is the way I don't want to do it, hehe. I was gonna do that but we have like 50 fields per table, so its basically a pain in the rump. and the fields are not in order via both tables that I can look across easily. Plus the experience of learning some coding would greatly benefit me. =)

 

[cmmrfrds]

In your criteria you could try converting all values to variant type.

Select * from tab1
inner join tab2 ON Cvar(tab1.field1) = Cvar(tab2.field1)