Extract values for a query.

B

Blanton

I have a field which holds a complete path and filename.
Iwant to use this field to extract information and place
them into individual fields. How to write that in a query.
How do extract left or right based on the first right "\"?
Secondly, how do extract the filename from the path. I
know I am close but yet seem so far? Help !!!
 
Top