Access Equivalent for @left in Excel

T

Tina L.

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.
 
D

Douglas J. Steele

Access has a Left function:

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

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.
Click to expand...

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

Jamie Collins

Douglas J. Steele said:
Access has a Left function
Click to expand...

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.

--
 
Top