Hi all. In access I cretae a table having my name ( first name+last name).Now i want to generate a login id as (2 letter in my first name, 2 letter from last name). eample is name: pallavi reddi i required login id :pare plase kindly tell me yar , how to do it in access..