Number data type blank entry 2

[evergrean100]

If I have a field that accepts rating numbers and a N/A in my Access 2003 database.

Choose rating: 1 2 3 N/A


N/A is not suppose to show anything in my database and 1 should show the number 1 and 2 the number 2 and the 3 the number 3.

Question is what would the data type be for this field??

I used text data type and it accepts the blank entry in my insert statement but when I changed it to Number data type it doesnt accept the blank ("") entry into the database.

Please advise.

Anyway I can get the number data type to accept a blank entry???

 

[AlexCuse]

why not use zero or 999 for the blanks?

There is also a setting in the table design you can enable to 'Allow Zero-Length Strings' (although I'm not sure this is there for number fields)

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[Golom]

If you want numerics to appear as empty (i.e. blank) fields then make sure that, in the definition of the field, the "Required" property is set to No and there's nothing in the "Default Value" property.

Then when you add a new record set the field to NULL or don't bother to set it at all.

For example

INSERT INTO myTable (Rating1, Rating2, Rating3, Rating4)
VALUES ( 1, 2, 3, NULL)

 

[evergrean100]

Thanks!