Filtering out the garbage

[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

 

[Phobos]

=MID([FieldName],9,2)

P