Filtering out the garbage

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

Hello ... Im using Access 2k

Tring to filter out every 9th and 10th character in a field.

Here is a sample of the data:

Trucks:#57:Brant Graff
Trucks:#57:Scott Smith
Trucks:#68:Chad Prince
Trucks:#68:Justin Steed


Im tring to get the query to just display the truck number (ie 57 and 68)
for this sample. I think there is a way but cant seem to figure it out.
Thanks
Chad
 
Back
Top