Year Field

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

Guest

Hello,

I have table that stores a "year" value. Is it better to have this field's
data type as a Text or Number value. There is no dates, just a year like
2004, 1999 etc..

Any suggestions ? Thanks in advance.

G
 
Hello,

I have table that stores a "year" value. Is it better to have this field's
data type as a Text or Number value. There is no dates, just a year like
2004, 1999 etc..

Any suggestions ? Thanks in advance.

G
Click to expand...

I'd use an Integer.

John W. Vinson[MVP]
 
Back
Top