Combining first letters of two text fields

Montemontgo

Registered User.
Local time
Today, 03:39
Joined
Oct 25, 2004
Messages
26
In a form I can easily combine and display the content of two text fields in a third text field with the formula =[field1] & [field2]. Very well. Now I would like to combine and display only the first letter of each of the two text fields. This I would expect to go somewhat like this =(letter,1,1[field1]) & (letter,1,1[field2]). How is the correct formula?
 
Combine

Try this:

=Left([Field1],1) & Left([Field2],1)
 
thanks trucktime, this is what my access help (in spanish) sais too but it definitly does not work in Access2000. It reports a syntax error.
Strange enough the german help sais =Links([Fieldname];1) ("links" is "left") while the spanish help sais =Izq([Fieldname],1) ( , against ; ) but neither works.
I'm frustrated
 
Really, I had no idea they changed the names of functions across different languages - links, gauche, налево, etc.

Are you sure you shouldn't just use Left?
 
... nope, "Left" doesn't work either. (Syntax error) Would there be any work around to get the first letter of a textfield? Something like "trunc" or "display" or the like. Access2000 help appears a bit strange to me. It sais to use the formula =Left([field],1) in a querry (?). I rather thought it is to be applied in a form. Of course there is always the possibility that I am not checking the hole issue. Help !
 

Users who are viewing this thread

Back
Top Bottom