Access Equivalent for @left in Excel

[Guest]

Hi,

I am pretty new to Access. I need to calculate a field in a report
depending on whether the 2 leftmost character in the field "Part #" are KB or
anything else. How do I do this in Access?

Thank you for your help.

 

[Douglas J. Steele]

Access has a Left function:

Left(MyString, 2) will return the two left-most characters.

 

[fredg]

Hi,

I am pretty new to Access. I need to calculate a field in a report
depending on whether the 2 leftmost character in the field "Part #" are KB or
anything else. How do I do this in Access?

Thank you for your help.

To find the first 2 characters in a field (or a String):
= Left([FieldName],2)

 

[Jamie Collins]

Access has a Left function

Does it? Jet has a LEFT function and VBA has a LEFT function (and
Excel has VBA). Then again, from the title, @LEFT is a Lotus 1-2-3
worksheet function, not Excel, so who knows anything <g>?

Jamie.

--