sql problem

[Lord Zarm]

ALTER TABLE tblEarningsDeds ADD AllowSplitOverride varchar(1)

I need to somehow tell that this field can be zero length... Its an access database I am working on....

I cant figure out what I need to do with the statement....

[malleyo]

I'm not all that familiar with ALTER TABLE, but I've read somewhere that you can do:

ALTER TABLE tblEarningsDeds ADD AllowSplitOverride varchar(1) NULL

or

ALTER TABLE tblEarningsDeds ADD AllowSplitOverride varchar(1) NOT NULL

to tell Access if Nulls are allowed or not.


Hope that helps!

Fiona