How do I set a field based on search results?

[cherold]

I have a database listing all my old, physical-media music. At the time I created it, instead of creating a media-type field, I just used the comments field to indicate if it was something other than vinyl. Now I've created a media-type field and I'd like to find an easy way to populate it. If the comments field contains "(T-" then it's a reel-to-reel tape (ID 4). "(c)" makes it a casette (ID 3). CD, of course, means it's a CD (ID 2). And if it's none of those, then it's vinyl (ID 1).



This isn't an ongoing issue, I just need something to set the media-types in one fell swoop and then in future I'll just set it manually for anything I add. Is there a way to do this via macro?

[pbaldy]

Not a macro, an update query. Since it's a one-time thing, I'd just run a query several times with a different criteria and a different value. For example:

UPDATE TableName
SET NewFieldName = 4
WHERE OldFieldname Like "T-*"

[cherold]

Beautiful, thanks!

[pbaldy]

Happy to help, and welcome to the site by the way!