Hello
I need help,I have a table in which one field is populated with numbers , I want to truncate this filed to 5 digits( some numbers are less than 5 and some are more).
for this field, I want to put a condition if it is greater than 5 digits, delete the rest of the characters( I mean if it is less than 5 digits leave it ).
in the query, I have this
myfield: Left([myfield],Len([myfield])-2)
how can I add if the condition for it?
I am not sure to add in creteria ..... how can I add if the condition for it ??
Len([myfield])>5 ????
Thank you .........
I need help,I have a table in which one field is populated with numbers , I want to truncate this filed to 5 digits( some numbers are less than 5 and some are more).
for this field, I want to put a condition if it is greater than 5 digits, delete the rest of the characters( I mean if it is less than 5 digits leave it ).
in the query, I have this
myfield: Left([myfield],Len([myfield])-2)
how can I add if the condition for it?
I am not sure to add in creteria ..... how can I add if the condition for it ??
Len([myfield])>5 ????
Thank you .........