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....
Printable View
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....
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