Batch set feild value, How-to?

[Grimalkin]

Here is what I would like to do. I use a program that indexes files. It
keeps data in a Access database. I want to change so data in it. Here is an
example

It has a field called 'Path' It contains data like 'C:\Folder'
It has a field called 'DiskLabel' It contains data like 'H:\'

I want to set the 'DiskLabel' field to match the drive letter of the 'Path'
field in all records.

Thanks for your help.

[rkc]

"Grimalkin" <Gr******************@hotmail.com> wrote in message
news:Q_****************@nwrddc02.gnilink.net...

Here is what I would like to do. I use a program that indexes files. It
keeps data in a Access database. I want to change so data in it. Here is an example

It has a field called 'Path' It contains data like 'C:\Folder'
It has a field called 'DiskLabel' It contains data like 'H:\'

I want to set the 'DiskLabel' field to match the drive letter of the 'Path' field in all records.

Skipping advice on not storing redundant data because you can always
parse DiskLabel from Path when you need it, something like:

UPDATE Table1
SET DiskLabel = Left$([Path],3);

[Grimalkin]

Thanks for the info. I know what you are saying about redundant data, I did
not create the database. I am not smart enough. It is the output of another
app. Music Libaray from wensoftware.com. Well I am going to see if I can
figure out what to do with my new found knowledge.

Thanks again.