Using Expression for Default Value
Thanks.
This worked great!
"Golfinray" wrote:
One way would be to do a query that just returns the one field with the
customer id that you want. Call it Q_Temp or something like that. Make it a
make-table query. Then go to sql view and type:
alter table yourtablename
add column customerID
Run the query and it should add the column to your table. Try it on a copy
of your table first.
"4charity" wrote:
I would like to automatically create the data for a field in my main customer
table. It is the ID code for the customer, which is the first 4 letters of
their last name, and the first letter of their first name. I am using the
expression:
=Left([LastName],4)&Left([FirstName],1).
This works fine in queries, but I really want it as the Default Value in my
table that info is entered into. Can this be done? I can't get it to work.
If not, suggestions on how to go about doing this?
Thanks.
|