Initial table

[n1ghts]

Hi guys

Anyone knows how to get the first 3 letters from the first name and the last name to be put in the initial table?

Thanks in advanced

 

[Ian Mac]

Hi guys

Anyone knows how to get the first 3 letters from the first name and the last name to be put in the initial table?

Thanks in advanced

Hi,

Firstly, I wouldn't put it in the Main Table with the names.
Simply using the Query itself as the base for any other Queries and Forms is the way you should do it.

What if Ian MacConnell changes his name????? IANMAC isn't valid any more.

But,

You can use:

YourName: Left([FirstName],3)&Left([LastName],3)

In the field part of a query.

So:

SELECT Left([FirstName],3) & Left([LastName],3) AS YourName FROM IntialTable