Link Excel table - found #num!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have data in excel e.g.

59
45
67
-
78
90

actually this is my students marks. simbol - show they absent for the paper.
I link the table. but at access it show

59
45
67
#num!
78
90

Q: any way to display both type of data?
or any way to hide #num! when print at report?

TQ
Param
 
Excel treats the values as numbers. When you enter a value that will be
construed as text, Access will indicate there is an error. Replace the -
with 0 and it should remove the error.
 
Back
Top