query to copy result of an expression in a field

[anchamal]

i've got these expressions in a query to extract parts of an mp3 file full path from a field and just let the name of the song.


exp: Mid([imported];[exp3]-[exp2];Len([imported]))
exp2: InStr([imported];"\")-4
exp3: InStrRev([imported];"\")
exp4: Left([exp];Len([exp])-4)

"exp4" is the clean name of the song.

now how can i update my "song name" field (which is empty) to be same as "exp4"
is it an update query?
if so how can i do it?

 

[pr2-eugin]

Simple answer, do not store that information. Calculated fields belong to Query not tables.

If you want this information to be displayed do that in Queries or Unbound text box controls on Forms. Do not store this information.

 

[David R]

The exception here would be if you're not confident all mp3s have a valid song title in the filename, and you need/want to be able to hand-type a title later. But even then you COULD set up a conditional field that looks for a hand-typed value first, then goes to the substring in the filename if there's nothing there.