adding an extension with find/replace

Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos. I need to add the .jpg extension to all 2,510 of them, so I can use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not figure
out how to add .jpg to the end of the ID number.

It would probably have been more appropriate to use an Update query to fix
the data in your table.

You could have set the path to "C:\Program Files\Datacard\ID Works\Photos\"
& [StudentID] & ".jpg"

If you've got the "C:\Program Files\Datacard\ID Works\Photos\" & [StudentID]
part in the field already, you should be able to add the ".jpg" to the end
now.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Dowling-Douglas" wrote in
message ...
Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos. I need to add the .jpg extension to all 2,510 of them, so I can
use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not
figure
out how to add .jpg to the end of the ID number.

I see insert query but I do not see Update query. I tried using find/replace
with the path as you typed it but can not get it to work.
an example of the id number is 07657191
what i get replaced is C:\Program Files\Datacard\ID Works\Photos\ & [new
photos] & .jpg



"Douglas J Steele" wrote:

It would probably have been more appropriate to use an Update query to fix
the data in your table.

You could have set the path to "C:\Program Files\Datacard\ID Works\Photos\"
& [StudentID] & ".jpg"

If you've got the "C:\Program Files\Datacard\ID Works\Photos\" & [StudentID]
part in the field already, you should be able to add the ".jpg" to the end
now.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Dowling-Douglas" wrote in
message ...
Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos. I need to add the .jpg extension to all 2,510 of them, so I can
use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not
figure
out how to add .jpg to the end of the ID number.

You can't use Find & Replace like that.

Where do you see Insert query, btw? In the Query builder, there's an Append
query and a Make Table query, but no Insert query. There is, however, an
Update query. (Look under the Query menu when the query's open in Design
mode)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Dowling-Douglas" wrote in
message ...
I see insert query but I do not see Update query. I tried using
find/replace
with the path as you typed it but can not get it to work.
an example of the id number is 07657191
what i get replaced is C:\Program Files\Datacard\ID Works\Photos\ & [new
photos] & .jpg



"Douglas J Steele" wrote:

It would probably have been more appropriate to use an Update query to
fix
the data in your table.

You could have set the path to "C:\Program Files\Datacard\ID
Works\Photos\"
& [StudentID] & ".jpg"

If you've got the "C:\Program Files\Datacard\ID Works\Photos\" &
[StudentID]
part in the field already, you should be able to add the ".jpg" to the
end
now.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Dowling-Douglas" wrote in
message ...
Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with
student
photos. I need to add the .jpg extension to all 2,510 of them, so I
can
use
a BLOB utility to embed the photos into the database. I have used the
find/replace feature to add the path: C:\Program Files\Datacard\ID
Works\Photos\0 (most of the ID numbers start with 0) but I can not
figure
out how to add .jpg to the end of the ID number.