Extracting parts of strings with query

[bozdog]

I have recently imported several fields from a spreadsheet(excel) and wish
to update a field using an update query. The particular field is imported as
a text string and defines a path for a particular graphic file. Each field
is unique and there are approximately 4000 records.A typical string I wsh to
edit is as follows

D:\diagrams\abc_123.tiff . (one of 4000)
D:\diagrams\abc_1234.tiff
etc
to
C:\diagrams\abc_123.tiff
D:\diagrams\abc_1234.tiff

Any help appreciated

[bozdog]

Typo on second string
should read C:\diagrams\abc_1234.tiff

"bozdog" <ia*******@optusnet.com.au> wrote in message
news:41**********************@news.optusnet.com.au ...

I have recently imported several fields from a spreadsheet(excel) and wish
to update a field using an update query. The particular field is imported as a text string and defines a path for a particular graphic file. Each field
is unique and there are approximately 4000 records.A typical string I wsh to edit is as follows

D:\diagrams\abc_123.tiff . (one of 4000)
D:\diagrams\abc_1234.tiff
etc
to
C:\diagrams\abc_123.tiff
D:\diagrams\abc_1234.tiff

Any help appreciated

[GrayJay]

"bozdog" <ia*******@optusnet.com.au> wrote:

I have recently imported several fields from a spreadsheet(excel) and wish
to update a field using an update query. The particular field is imported as
a text string and defines a path for a particular graphic file. Each field
is unique and there are approximately 4000 records.A typical string I wsh to
edit is as follows

D:\diagrams\abc_123.tiff . (one of 4000)
D:\diagrams\abc_1234.tiff
etc
to
C:\diagrams\abc_123.tiff
D:\diagrams\abc_1234.tiff

Any help appreciated

If the table is tblPath and the first field name is Path1 then Path
2 is given by:

SELECT "C"+Right([Path1],Len([Path1])-1) AS Path2
FROM tblPath;

--
»«»«»« Graham »«»«»«