Use of left in a query

[Guest]

If I want to use left e.g., left(len([AssignNo]),4) for Assignment# 123456
would get 1234 what if the user entered 123 it returns a null so how so take
care of that?

 

[Al Camp]

JOM,
IF(Len(AssignNo) < 4, [AssignNo], Left([AssignNo], 4))

 

[Guest]

If you use left 4 on 123 it should return 123

The problem is with the left that you gave us
left(len([AssignNo]),4)

Should be without the len

left([AssignNo],4)