Using Left Function in table design.
- From: "Jason" <wills.jason@xxxxxxxxx>
- Date: 25 Jan 2006 01:58:32 -0800
I am trying to create a simple database, but it's proving too complex
for me!!!
I have only just started a new database and am trying to have two
fields in a table:
the first holding the first name of a person (FirstName) and the second
to be the first charactrer of that name.
i am using the default value property for the second field of
"=Left([FirstName],1)", but i am getting error messages when tryign to
save it.
does anyone know what i am doing wrong, i would like it so that the
first could be entered as "Jason" and the second field would
automatically enter "J".
can anyone helps, thanks
Jason
.
- Follow-Ups:
- Re: Using Left Function in table design.
- From: andrewbuilder
- Re: Using Left Function in table design.
- From: Wayne Gillespie
- Re: Using Left Function in table design.
- Prev by Date: Regional options: how to change from VB
- Next by Date: Re: display a string as it is
- Previous by thread: Regional options: how to change from VB
- Next by thread: Re: Using Left Function in table design.
- Index(es):
Relevant Pages
|
