Left () function in a query

[Dega]

INSERT INTO tblRoomGroups ( RoomGroupName )


SELECT [Forms]![frmCustomers]![left("firstname",1)] & " " & Forms!frmCustomers!lastname AS Expr1;

The above does nothing for the firstname and other attempts give me various results which don't work.

Trying to get the first letter of the firstname with the lastname.

Thanks

[pbaldy]

Try

INSERT INTO tblRoomGroups ( RoomGroupName )
SELECT Left([Forms]![frmCustomers]![firstname], 1) & " " & Forms!frmCustomers!lastname AS Expr1;

[Dega]

Thank you!

[pbaldy]

No problemo!