Hey, Big Jim here:

I have two columns in a table. It looks like this

COLUMN A COLUMN B
20020215
20020312
20020421

Both A and B are text fields. When I attempt to use the MID, LEFT, and RIGHT Functions to UPDATE COLUMN B to show the date as "02/15/02", I get a Type Conversion Failure and no updates occur. B

Both A and B are TEXT fields. Any thoughts here?

Thanks in advance!

Big Jim

Go to any code page where you see the debug menu. Select Tools > References and uncheck any items marked "MISSING".

Jack,

Big Jim sends his many thanks!


Big Jim