G
Guest
Thanks in advance.
Platform: Access 2002
tbl_Emp is a linked table to Excel table named Emp.xls.
Emp.xls has a field named as Emp_ID, with number( eg. 1234) and text type
(eg. manager, supervisor, ...).
Naturally, tbl_Emp's Emp_ID has an error such as "#Num!".
Is it possible to change "Num!" to -1 in a new calculated field New_Emp_ID?
Platform: Access 2002
tbl_Emp is a linked table to Excel table named Emp.xls.
Emp.xls has a field named as Emp_ID, with number( eg. 1234) and text type
(eg. manager, supervisor, ...).
Naturally, tbl_Emp's Emp_ID has an error such as "#Num!".
Is it possible to change "Num!" to -1 in a new calculated field New_Emp_ID?