Left Function Message

[Brogrim]

I am trying to use the left function to extract the first letter from every name so I can use them in a report in alphabetical order

I am using this function: =Left([Name],1)

I am getting the following message

Undefined Function "Left" in expression

any suggestions

 

[lupins46]

You have a problem with library references.
Open any module in design view.
Choose Tools>references from the menu.
Deselect & reselect any marked as Missing.

 

[Brogrim]

Worked perfect, thank you