Check Constraint in MS Access 2000

[pollo4]

Hi!
Im creating a table with an SQL query and I want to set a validation rule to a numeric (long) field. My db is in MS Access 2000.
I need something like this (but this doesnt work):

CREATE TABLE tablename (fieldname LONG CONSTRAINT CHECK constrainname (>=0 and <=50000))

Does anybody know who to do this correctly?

Thanks a lot!

Pollo