SELECT (Left([Name], 1) & Format([Date], "yyyymmdd") & Right([ID], 1)
AS MyTextString
FROM MyTableName;
Also, do not use Name or Date as the name of a field. They and many other
words are reserved words in ACCESS, and can create serious confusion for
ACCESS and Jet. See these Knowledge Base articles for more information:
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default...b;en-us;286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763
--
Ken Snell
<MS ACCESS MVP>
"galsaba" <ga*****@aol.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I created a form with the following fields:
ID (AutoNumber)
Date (Date / Time)
Name (Text)
I want to create a query that will take
the first letter of the Name & Date & ID & last digit of the ID.
Thanks,
galsaba