Return the values up to a certain character

[ECEK]

I have a list of codes and I just want to extract everything up to the "/" character. I can do this in excel but cant figure out the query formula in Access!!

4256782/677
232415526728882/677
5634252773/6772

Result =

4256782
232415526728882
5634252773

many thanks you beautiful people !

 

[plog]

You would use the Mid function (http://www.techonthenet.com/access/functions/string/mid.php) to get a substring, and the InStr function (http://www.techonthenet.com/access/functions/string/instr.php) to find out where that slash is.

 

[jdraw]

Well, you could just use excel --if that is an option and your go to product.
You could use InStr and Mid as plog says, and/or you could use the Split() function

 

[ECEK]

Did it myself:

Left([Field1],InStrRev([Field1],"/")-1)

....the "Well, you could just use excel" wasn't helpful!

 

[MarkK]

If you want the numeric value to the left of alpha chars in a string, use Val().

Val([Field1])