Access Quickie

[suarve]

Not used Access in years, can some help me out?

I have a field (called ImagePath) in a table with the following info:

C:\Documents and Settings\user\My Documents\WEB PICTURES\RPB125.jpg

I need to run some sort of update query that stripts evertything away bar the actual image file - RPB125.jpg.

Can anyone help?

 

[suarve]

Absolutely superb!

Thanks!!