How to convert Date to String

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

Left(Name, 1) & CStr(Date) & CStr (ID) & Right(CStr(ID), 1)

--
Message posted via http://www.accessmonster.com

How to convert Date to String

re: How to convert Date to String

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about