Automatically inserting part of a file name into another field

[Guest]

I am importing a list of file names and wish to insert into another field the
file name without the file extension.

Example: tblPhotos has two fields: PicID (key) and PicName

file name 540987.jpg is imported into the field PicID
I would like to automatically populate the field PicName with the 540987 so
that it can be related to a key field in another table.

Thanks in advance for you help......

 

[John Nurick]

Use an update query, and update PicName to

Left([PicID], Len([PicID]) - 4)

 

[Wendy Blackstone via AccessMonster.com]

Thanks, that did just what i wanted it to.....that will teach me to get rid
of programming books!

Wendy