Having (I hope) sorted the #Num! problem in Access I find
some fields datatype is wrong. I want text but Access makes it a
number
Not all fields though - and I can't see why.
Is there a method to make every cell text? I've been selecting a
column, right clicking - Format Cells - Catagory - Text
Then re-linking but it's still a Number in Access.

Many thanks for a solution.

Cheers - Kirk


--
kirkm
------------------------------------------------------------------------
kirkm's Profile: http://www.excelforum.com/member.php...o&userid=35814
View this thread: http://www.excelforum.com/showthread...hreadid=558732