Unanswered: MS Access 97 - Auto "Increase" a letter
Hi guys and gals.
I have a table with a field with the default value as "A". I need create a query (preferable to using VB), that when a new record is created the letter "increases" by one - i.e. the new record's value in this field is automatically "B", then the next new one will be automatically "C" and so on.
Any ideas as to how I can achieve this? Preferably using a query.
A default value is the value that is entered in a field any time a new record is added to a table and no value is specified for that particular column. To set a default value for a field, use the DEFAULT keyword after declaring the field type in either an ADD COLUMN or ALTER COLUMN clause.
ALTER TABLE tblCustomers
ALTER COLUMN Address TEXT(40) DEFAULT Unknown
Notice that the default value is not enclosed in single quotes. If it were, the quotes would also be inserted into the record. The DEFAULT keyword can also be used in a CREATE TABLE statement.