I have a query that is looking up the first part of a string in a field. The first part is separated by a "-"
i.e. Books - Number 7 DOC 6180
Due to the fact that the first part can be any length, I just need the first part of that field.
I wrote this below, and it works for the BOOKS one...but what am I missing?
Left([Cell_Loc],6)
i.e. Books - Number 7 DOC 6180
Due to the fact that the first part can be any length, I just need the first part of that field.
I wrote this below, and it works for the BOOKS one...but what am I missing?
Left([Cell_Loc],6)