I need to create a username from the first 3 letters of the first name and 2 letters form the last name with a sequential number. Can anyone help as this is driving me mad. Thanks dotti
I need to create a username from the first 3 letters of the first name and 2 letters form the last name with a sequential number. Can anyone help as this is driving me mad. Thanks dotti
Well it's hard to tell how far you have got, as you didn't give us much to work on in the terms of detail. What have you tried? Do you have a query already?
If you havent started this link might help:
http://www.techonthenet.com/access/f...ing/concat.php
The below link should help you retrieve the 3 characters from the first name and the 2 characters from the last name:
http://www.techonthenet.com/access/f...tring/left.php
As Rixxe said there are not enough details but perhaps the following link is useful (depending on what you have already):
http://www.techonthenet.com/access/f...umeric/max.php
Sorry about the lack of detail this is what I have so far.
=Left([FirstName],3) & Left([LastName],2) & Right([UserName],4)+1
I have pt this in to a form but I wondered if it was possible to put it into a query.The outcome I am looking for is a registration form that when you put in your first and last name in it takes the first 3 in first name and first 2 in last name with a sequential number that runs from a set of details I already have.