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 !
4256782/677
232415526728882/677
5634252773/6772
Result =
4256782
232415526728882
5634252773
many thanks you beautiful people !