Year Field

[Gsurfdude]

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

 

[John Vinson]

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

I'd use an Integer.

John W. Vinson[MVP]