add txt to end of records in update query

[Rogdool]

I'm missing something simple.

I'm updating records in a field in a table to add "jpg" to the end of each record, unfortunately it leaves a space between the record and the new text.

here's what I have

Update to : ([txtImageName] & "jpg")

"Result : 011230 jpg" "but need: 011230jpg"

Any Ideas???

 

[Dugantrain]

try:
Trim(([txtImageName]) & "jpg")

 

[Rogdool]

No luck same result, still a space.

 

[Pat Hartman]

You need to Trim() the source field not the result.

Trim([txtImageName]) & "jpg"