Calculated column in table not working

[JRodko]

Hello,

I swear that I had this working at one point, but now it is kaput. I am trying to build a calculated column in my table that returns a string.

In the expression builder, I enter the following:

"SRC" & Right([SampleID],6)



The error I get is 'Could not find field 'Right'. Doesn't make any sense to me. I have tried all variations of quote placement and it never works. Results type is set to Short Text but that should not matter.

Thanks

[kd2017]

Don't do it!
http://allenbrowne.com/casu-14.html

[JRodko]

I should have known Allen Browne would set me straight.